Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

Update two fields in an API call?

Is it possible to update two fields in one API edit call?  I need to update two checkboxes in one API call and haven't had success getting it to work so far.

------------------------------
Paul Peterson
------------------------------
APIs and custom code
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      5 years ago
      I'm sure there is a better way to do this overall.  The intent is to uncheck a checkbox, then re-check the checkbox and open the record for editing.  I need to temporarily disable custom data rules during this process.  The end result needs to be, uncheck one box, check another check box to bypass the data validation, then recheck the first checkbox an uncheck the box to bypass data validation.

      This is my starting point. 

      If([Send Email?],
      "<a class='Vibrant Primary' style=\"width:75px; text-align: center;\" href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&###&_fid_560=0&rdr="& URLEncode(URLRoot() & "db/" &Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&###&_fid_560=1&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])) & "'>Re-Send</a>"
      )

      ------------------------------
      Paul Peterson
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        To do sequencial successive updates the syntax for a URL formula field is this

        $URLONE
        & "&rdr=" & URLEncode($URLTWO)
        & URLEncode("&rdr=" & URLEncode($URLTHREE))

        I suggest that you get a simple formula URL field working first, before attempting the more difficult syntax for the Rich Text field type

        updates

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------