URL Formula how to add "where?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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!
Photo of jeanne

jeanne

  • 374 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 2,100 Points 2k badge 2x thumb
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
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
If([Status] = "WIP", $URL, "") 
Photo of jeanne

jeanne

  • 374 Points 250 badge 2x thumb
thanks, that was simple!