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 Pe...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you post your code?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
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__YouTo 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
------------------------------- I was aware that I could use the approach you outlined. This user is working through a VPN with extreme;y tight data control. As a result, the load time can be a little sluggish.
The syntax issues were addressed before posting. I was hoping to find a way to minimize the number of API calls.
Thank you for your suggestion.
------------------------------
Paul Peterson
------------------------------