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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
No problem



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

& "&_fid_352=" & URLEncode("true")
& "&_fid_317=" & URLEncode ([Rate - Cost - GRI Total])
& "&_fid_163=" & URLEncode ([Rate - Cost - GRI Total]);

IF([Another Field] = "X",

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

)