Button to toggle a checkbox in report
I have a report with a checkbox. I would like to create a button on the report that would toggle the checkbox on or off, depending on it's current status. I would like the toggle button to change l...
Forum Discussion
I tested this and could not get it to fail. I'm not sure what else to suggest. Any chance you were clicking too fast before the page got a chance to refresh
var bool XXX = not [checkbox];
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_26=" & $XXX ;
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
var bool XXX = not [checkbox];
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_26=" & $XXX ;
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
The XXX user defined variabvle is evaluated only once so only the first toggle works.
There might be a native solution but there certainly is a script solution.
Unfortunately I am about to shut down for the weekend. Have a good one yourself.
There might be a native solution but there certainly is a script solution.
Unfortunately I am about to shut down for the weekend. Have a good one yourself.