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);"
I'm trying the same thing with a slightly different take with a pop up display after clicking. However, The button is not toggling the checkbox field. Below is my code:
var bool NewToggle = If ([Toggle Submit] = true, false, true);
var text URL = URLRoot() & "db/" & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_214=" & $NewToggle & "apptoken=jzbh5tctc9cbhb5dkskndwjcgca";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"$.jGrowl('Your project proposal has been submitted', {life: 5000, theme: 'jGrowl-green'});" &
"});" &
"void(0);"
fid_214 is the [Toggle Submit] field. not sure where i'm going wrong.
Thanks
var bool NewToggle = If ([Toggle Submit] = true, false, true);
var text URL = URLRoot() & "db/" & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_214=" & $NewToggle & "apptoken=jzbh5tctc9cbhb5dkskndwjcgca";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"$.jGrowl('Your project proposal has been submitted', {life: 5000, theme: 'jGrowl-green'});" &
"});" &
"void(0);"
fid_214 is the [Toggle Submit] field. not sure where i'm going wrong.
Thanks
