URL Formula how to add "where?

  • 0
  • 1
  • Question
  • Updated 1 year 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 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k 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

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

jeanne

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