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 have the formula (I had to add ; after the [Process for Submission].
// make a formula variable to be the opposite of the checkbox condition.
var bool NewValue = not [Process for Submission] ;
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_9=" & URLEncode($NewValue);
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
The button is on the form and when clicked it re-loads the page but the value of the checkbox doesn't change.
// make a formula variable to be the opposite of the checkbox condition.
var bool NewValue = not [Process for Submission] ;
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_9=" & URLEncode($NewValue);
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"
The button is on the form and when clicked it re-loads the page but the value of the checkbox doesn't change.