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
maybe I worded the wrong then....I guess what i'm trying to achieve is the below to update only where [cost-carrier] = "APL"

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

we have many records in our cost table under [carrier]="APL" and this button needs to add the [APL GRI Amount] for only those records. 

I'm guessing the IF statement might not be the rate choice....?