Forum Discussion

jrossausiscom's avatar
jrossausiscom
Qrew Assistant Captain
5 years ago

URL Button, Create one record in 3 tables

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....
APIs and custom code
Buttons
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------
jrossausiscom's avatar
jrossausiscom
Qrew Assistant Captain
5 years ago
Interesting.  I am creating the variables now.

What is the difference between URLEncode and URLRoot?

------------------------------
John Ross
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    I completely different things.URLRoot()

    Will provide the string mycompany.quickbase.com

    URLEncode Takes care of the issue that in the Internet certain characters are not allowed including spaces and many of the characters on the top row of the keyboard. They are illegal characters for the Internet. So they need to be URLEncoded.

    As for why the syntax needs to be nested like that, I have no idea about somehow I figured that out about 15 years ago and it has always worked solidly for me.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • jrossausiscom's avatar
      jrossausiscom
      Qrew Assistant Captain
      5 years ago
      Got it.

      So to make sure I am on the same page, when you said to define the URL's, do I need to define the whole table action group as a variable?

      I created the following as a test, this is nice as I did not know that QB allowed user variables.

      var text ConFigTable = [_DBID_DEVICE_CONFIG_RECORDS];
var text FinancialTable = [_DBID_FINANCIALS];​


      This gives me the following:

      & "db/" & $ConFigTable & "?a=API_AddRecord"
& "&_fid_6=" & URLEncode([Staging ID])
& "&_fid_17=" & URLEncode(Today())


      Or should it be as such:

      //var text TEST = (URLRoot() & "db/" & $ConFigTable & "?a=API_AddRecord" & "&_fid_6=" & URLEncode([Staging ID]) & "&_fid_17=" & URLEncode(Today()))


      I'm more of an excel guru, so the syntax here isn't as clear to me as VBA and such is.



      ------------------------------
      John Ross
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        Its the second syntax without the extra brackets and ending with a semicolin.



        var text TEST = URLRoot() & "db/" & [_DBID table name goes here] & "?a=API_AddRecord" & "&_fid_6=" & URLEncode([Staging ID]) & "&_fid_17=" & URLEncode(Today()));


        var text TestTwo= "some other URL";

        var text TestTHREE = "some other other url";

        $TEST
        & "&rdr=" & URLEncode($TestTwo)
        & URLEncode("&rdr=" & URLEncode($TestTHREE))

        Last URL needs to land the user on a form or a report or the homepage of the app or else the system will be compelled to spew back to you the XML success message. 






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