URL Formula how to add ""where?

Question

This formula is working. it sets field 33 (STATUS) to "Claimed" , but i what to add a where? want to only update the current record to "Claimed" if the field STATUS is currently set to "WIP", how is this done?

var text URL = URLRoot()&"db/"& [_DBID_V2_0_COGS] &"?a=API_EditRecord&rid="&[Record ID#]&"&_fid_33="&URLEncode("Claimed")&"&z=" & Rurl();

thanks you any suggestions!

ChuckGrigsby · Answer

If([Status]="WIP", URL, "")  If this is true it returns URL variable. Otherwise it returns blank so clicking the button shouldn't do anything if clicked and it's not WIP

Sign up

Login to the community