URL Button to check a checkbox
I am trying to have a URL Button to check a checkbox if that checkbox is empty and do nothing if it is already checked. I would also like this button to be pressed from an embedded report. Essentiall...
Forum Discussion
Justin, I see that you found my app in the Exchange
Here is what you need
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_55=1";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
Change 55 to your checkbox fid.
this syntax refreshes the whole page, even when clicked off a child record on an embedded report on form, or on a report.
Here is what you need
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_55=1";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
Change 55 to your checkbox fid.
this syntax refreshes the whole page, even when clicked off a child record on an embedded report on form, or on a report.
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 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.')")