Forum Discussion

jeannejeanne's avatar
jeannejeanne
Qrew Cadet
8 years ago

URL Formula how to add ""where?

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!

3 Replies

  • 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