Forum Discussion

olivermah's avatar
olivermah
Qrew Assistant Captain
7 years ago

button to update a field only when another field value = X

I'm trying to create a button where the user can push it to change a value in the field to one that is specified by the user.  however only when another field is equal to a certain value. the below co...
APIs and custom code
olivermah's avatar
olivermah
Qrew Assistant Captain
7 years ago
so i've done this but for some reason the button won't show up even when i click display as a button, never ran into this before.

var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]

& "&_fid_77=" & URLEncode("[APL GRI Amount]");

If([Cost - Carrier]="APL",

"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);")