Discussions

Back to discussions
Expand all | Collapse all

URL Formula how to add ""where?

  • 1.  URL Formula how to add ""where?

    Posted 07-09-2017 15:13
    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!


  • 2.  RE: URL Formula how to add ""where?

    Posted 07-09-2017 15:25
    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


  • 3.  RE: URL Formula how to add ""where?

    Posted 07-09-2017 15:52
    If([Status] = "WIP", $URL, "") 


  • 4.  RE: URL Formula how to add ""where?

    Posted 07-09-2017 17:40
    thanks, that was simple!