Forum Discussion
EvanMartinez
6 years agoQrew Elite
Hi Todd,
Another alternative that might be helpful for checking the status of the checkbox is to instead use the numeric value that the checkbox fields utilize. 1 for True and 0 for false. So something like.
var numeric XXX = If([Checkbox]=1, 0,1);
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_26=" & $XXX ;
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
That way you are pushing the numeric value into your checkbox field to request the change which might process differently from the not syntax.
Another alternative that might be helpful for checking the status of the checkbox is to instead use the numeric value that the checkbox fields utilize. 1 for True and 0 for false. So something like.
var numeric XXX = If([Checkbox]=1, 0,1);
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_26=" & $XXX ;
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
That way you are pushing the numeric value into your checkbox field to request the change which might process differently from the not syntax.