Skip to main content
Question

URL Button to create 22 child records with one click

I need a button that will create 22 child records with one click. the code below is what I have.

var text URLONE = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 850 in Nordic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLTWO = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 850 in GenTran"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLTHR = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 855 in Nordic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLFOU = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 855 in GenTran"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLFIV = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 856 in Nordic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLSIX = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 856 in GenTran"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLSEV = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 860 in Nordic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLEIG = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 860 in GenTran"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLNIN = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 852 in Nordic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLTEN = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 852 in GenTran"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLELE = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 846 in Nordic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLTWE = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 846 in GenTran"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLTHRI = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 812 in Nordic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLFOUR = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 812 in GenTran"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLFIF = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 820 in Nordic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLSIXT = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup 820 in GenTran"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLSEVE = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup Nordic Corp"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLEIGH = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup Nordic Store"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLNINE = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup Nordic Shipping"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLTWEN = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup Nordic BoxLogic"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLTWONE = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup Nordic Packing Slip"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));
var text URLTWTWO = URLRoot()& "db/" &[_DBID_TASKS]& "?a=API_AddRecord" & "&rid=" & [Project ID]& "&apptoken=de8p2zcbz4vzwvbs54xgpbh3b8au"& "&_fid_202=Setup Nordic Shipping Label"& "&_fid_48="&URLEncode([Project ID])& "&_fid_77="&ToText(Today())& "&_fid_176="&ToText(Today()+ Days(13));

var text URLRER = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Project ID];

$URLONE 
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHR))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOU)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIV))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSEV))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLEIG)))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLNIN))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLTEN)))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLELE))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLTWE)))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLTHRI))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIF))))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIXT)))))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSEVE))))))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLEIGH)))))))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLNINE))))))))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLTWEN)))))))))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLTWONE))))))))))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLTWTWO)))))))))))))))))))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLRER))))))))))))))))))))))



My obvious problem is that code is too long and will not work. I only get: " HTTP Error 400. The size of the request headers is too long."



Does anyone have a way to make this work? Or a way to create 22 records with the push of a button?
      This topic has been closed for replies.

      Can you just use the Clone button to clone a parent record with 22 child records?

      Click the HOME button >> Settings >> App Management >> Manage App Content >> Copy Master and Detail Records.

      I use a different method with a formula - rich text field. But I  have never had a need to create that many records. The test of mine only made 18 records with only 4 fields being populated. Our buttons normally populate many fields and when we reach a limit on multiple record creation we split the work into multiple buttons (always 2 buttons). Here is the code for 18 records, I am very low code but I am sure there are scripting solutions that would be able to do exactly what you are looking for.

      // Begin button style
      var text bgcolor = "#0077B5";
      var text txtcolor = "white";
      var text style = "style=\"text-decoration: none; box-shadow: 3px 3px 1px #888888; background:" & $bgcolor & "; border-radius: 3px; padding: 5px 8px; color: " & $txtcolor & "; display: inline-block; font-weight: normal;font: 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow:none;";
      // End button style

      var text URL=  URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Install Price]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])

      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="

      & (URLEncode(URLRoot() & "db/"& [_DBID_Billing]  & "?a=API_AddRecord"
      & "&_fid_6=" & [Location ID]
      & "&_fid_7=" & [Configuration Charge]
      & "&_fid_8=" & [Project - Text Project ID]
      & "&_fid_10=" & URLEncode([Task Number])
      & "&rdr="



      )))))))))))))))))))))))))))))))))));

      //create button and execute the add record
      //this should also return you to where the button was pressed

      "<a " & $style & " href=\"javascript:" & "$.get('" & $URL & "', function(){" & "location.reload();" &
       "});" & "void(0);\"> Button test </a>
      I don't mean to slight your efforts (I will be happy to show you how to do this) but my humorous reply might help you and others understand why you don't want to do it this way and what is really happening when you "redirect".

      It is obvious the formula is gigantic so I will not even comment on this further.

      Let's say you needed to make a recipe with 22 ingredient and you have to go shopping for everything. Would you prefer to make 22 trips from your car to the checkout purchasing one item at a time or would you just make one trip and purchase all 22 ingredients at once?

      Instead of using ?a=API_AddRecord 22 times you want to use ?a=API_ImportFromCSV once with CSV representing 22 records of data..

      I will put it on my todo list to show you the code but I have other stuff to attend to now.
        Your formula suggests to me to that you are in the retail industry and you are rolling out a new Project to 22 different Stores and you want to track that process.

        There are a ton of problems with your formula including the conceptual problem that you are adding a [Project ID] value through a rid parameter for the API_AddRecord method. There is no rid parameter for API_AddRecord, If your formula worked QuickBase was just ignoring the parameter as it has no meaning to the API_AddRecord. It is hard to see these errors when the formulas are gigantic or poorly formatted. The script solution below is vastly shorter and much more maintainable. As you continue this project you will probably find that there are additional child fields that you may want to initialize based on other fields and criteria. This solution can easily accommodate those future requirements.

        When I create a public demo I have to make assumptions to simplify the problem, change some inconsequential details, and construct the demo so I don't have to maintain it in any substantial way.

        I created this simple demo that has two tables - Projects is the parent table and Stores is the child table.

        You are free to click the button to create new Store records or even a new Project record. Bear in mind that others may have already clicked on the button and create their own batch of Store records before you created yours.

        Store Management Thingy
        https://haversineconsulting.quickbase.com/db/bngmqviem

        Pastie Database
        https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=628
        I have a button that does an API ImportfromCSV and adds 9 records in one API call. This might solve your problem.  I set my CSV in a variable and then just pass it into an URL.  If you have yet to solve this problem I can post the formula so you can see it. 
        Also if Dan has any problems with this I would like to know because I am interested in his thoughts about this native approach. 
        Terms & ConditionsAccessibility statement