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. - Dan, in my experience, the button code is refreshed when the record refreshes, right?
- I will follow up later. I answered in haste and have to double check what I wrote!
- It still seems to stop toggling the checkbox on the 3rd click. I have even waited a few mins and tried gain to confirm that there is no timing issue. No luck. Is there another way to approach this? I need a simple way for my manager to remove a record from his view.
- Are you trying to refresh a particular report after each click?
- You can use this syntax
Define URLONE as the code to update the checkbox.
Define URLTWO as the report.
$URLONE
& "&rdr=" & URLEncode($URLTWO) - Yes, the button displays in a report and I would like the report to refresh.
- So URLONE would be this
var bool XXX = not [MD Approval (2)];
var text URLONE=
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_87=" & $XXX & "&apptoken=XXXXXXXXXXX";
var bool XXX = not [MD Approval (2)];
var text URLTWO=
URLRoot() & "db/" & Dbid () & "?a=q&qid=xx;
$URLONE
& "&rdr=" & URLEncode($URLTWO)
Fill in xx with the report id# - Whooooooot!!! This seemed to have worked. I hit the button 20 times and it worked every time. Thanks for sticking with me and the great help!!!!
- Thx for letting me know.it worked.
