Update all records in a specific report
I have a payroll application that's being developed. I need to take the records which have been approved and export them to be sent to the 3rd party payroll provider. At some point before/after the ...
Forum Discussion
I'm not sure what the "Multiple Steps" are but you can make a simple formula URL button to Toggle check the box and then trigger the ACTION when the checkbox is changed.
This should work to do that
// make a formula variable to be the opposite of the checkbox condition.
var bool NewValue = not [my checkbox field]
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_55=" & URLEncode($NewValue);
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
Change the 55 to the field ID of you checkbox field.
Change the ACTION to trigger on any time the check box is checked.
Take the checkbox off the form and just show the URL button in View mode.
This should work to do that
// make a formula variable to be the opposite of the checkbox condition.
var bool NewValue = not [my checkbox field]
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_55=" & URLEncode($NewValue);
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
Change the 55 to the field ID of you checkbox field.
Change the ACTION to trigger on any time the check box is checked.
Take the checkbox off the form and just show the URL button in View mode.