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.
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.')")
)
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.')")
)