URL Button, Create one record in 3 tables

Question

Is it possible to add records to more than one table with a URL button?  Below is a generic example of what I was trying to do:
//Create a record in Device Config Records, then load in the data.  PRIMARY
(URLRoot() & "db/" & [_DBID_CONFIG] & "?a=API_AddRecord&_fid_6=" & URLEncode ([Staging ID])

//Create a record in Financial Records, then load in the data

(URLRoot() & "db/" & [_DBID_FINANCIAL] & "?a=API_AddRecord&_fid_6=" & URLEncode ([Staging ID])

//Return to Staging Request
& "&rdr=" & Dbid() & URLEncode("?a=er&rid=") & URLEncode ([Staging ID])​
​The error I receive says "there are extra characters beyond the end of your formula".  I presume I am using the wrong syntax?------------------------------John Ross------------------------------

MarkShnierYou · Answer

Here is the syntax for nest successive URL calls. Define the URLs as formula variables.

and then

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

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

Sign up

Login to the community