URL Button to check/uncheck a check box
Is it possible to use conditional logic with an api call? I would like to create a URL button to check or un-check a checkbox depending on the state it is in
Forum Discussion
No Problem
Here is an example of a URL Formula field
var text NewCheckboxValue = IF([Status]="New","0","1");
var text URL= URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord"
& "&rid=" & URLEncode ([Record ID#])
& "&_fid_7=" & $New Status
& "&apptoken=" & "XXXX";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
That last stuff is just boilerplate code (as long as you name your formula variable URL) which refreshes the page.
Here is an example of a URL Formula field
var text NewCheckboxValue = IF([Status]="New","0","1");
var text URL= URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord"
& "&rid=" & URLEncode ([Record ID#])
& "&_fid_7=" & $New Status
& "&apptoken=" & "XXXX";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
That last stuff is just boilerplate code (as long as you name your formula variable URL) which refreshes the page.