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 labels (ie. True or False) based on the current value of the checkbox. Finally, I'd like to have the report stay on the screen. It can refresh, but I'd prefer it to remain at the report.
This seems to be beyond my skill level. Can anyone help me create this?
My current issue is that the button does not seem to work consistently. It will toggle the checkbox the first time I click it, but will not toggle it on subsequent clicks. Below is my code. Any Ideas? var text XXX = If([MD Approval (2)]=false,"true",[MD Approval (2)]=true,"false");
var text URL =URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]& "&_fid_87=" & $XXX & "&apptoken=XXXXXXXXXXXXXX";
Here you go.
var bool XXX = not [MD Approval (2)];
var text URL =URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]& "&_fid_87=" & $XXX & "&apptoken=XXXXXXXXXXX";