URL Button to check a checkbox

Awesome, that worked perfectly. Thank you!

I do have another similar question. I have time cards in my app with buttons that fill in the Time in and the Time out fields. I would like to change my code to do something similar where it will still fill out the time but refresh the current page, that way they can be done inside of embedded reports as well. My code for the clock in button is:

If(IsNull([Time In]),
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_10=" & URLEncode (Now())
&"&rdr=" & URLEncode(URLRoot()& "db/" & [_DBID_TIME_CARDS] & "?a=dr&rid=" & [Record ID#]),
"javascript:alert('You are already clocked in.')")

I think that would be

var text URL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_10=" & URLEncode (Now());

var text JavascriptDoAndRefresh =
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);";





If(IsNull([Time In]),

JavascriptDoAndRefresh,

"javascript:alert('You are already clocked in.')")
)

I'm getting a syntax error:
The argument list of the function JavascriptDoAndRefresh must begin with a left parenthesis.

I'm looking through trying to figure out where the argument list is as I have a beginners level of knowledge on javascript but maybe you can find the issue faster than me.

I solved it by taking out the var text JavascriptDoAndRefresh and just putting the logic inside of the if statement like this: 

var text URL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_10=" & URLEncode (Now());

If(IsNull([Time In]),

"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);",

"javascript:alert('You are already clocked in')")

OK, so all good now?

Yup, I think it is all sorted now. I appreciate your help.

I do have a quick question though, is there any documentation or a guide that explains the javascript syntax for quickbase? I have seen the beginning guides but they are extremely basic and aren't a very good help in trying to figure out more complicated URL Forumlas

:) As far as I know the only resource is scraping answers off this forum and saving them.  I have an app with a table where I save all my favorite tricks.  The only other possible resource is if any of the Quick Base university videos cover it.

If you just want to use the easy javascript,  It's basically that code you are using to refresh the page along with this one below which will do the edit, but will not refresh the page.  Some times you do not want to refresh the page as it delays the next click and jiggles the screen around on the user, when they have multiple clicks to do.



var text URL = URLRoot() & "db/" & "?act=API_EditRecord&_fid_80=1&rid=" & [Record ID#];

"javascript:" &
"$.get('" & 
$url & 
"',function(){" &
"$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &
"});" &
"void(0);

Hi,

I have the same requirement. I have been using the script in a "formula URL" field. However its not working. Could you please help me?

Regards,
Ravi

------------------------------
Ravi Siddana
------------------------------

Hello, is there an update to this code given the changes with javascript?

------------------------------
Kristen Brown (she/her)
------------------------------