Forum Discussion

JoshuaCase's avatar
JoshuaCase
Qrew Cadet
6 years ago

How to Add Many Records in seperate table from a form URL Formula button

I am looking to create a formula URL button that creates multiple tasks associated with a single project.  Each task is unique with a different task name BUT it does follow a template so all tasks are...
APIs and custom code
Button
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
I suggest that you use the native functionality to have the system create either a duplicate of an existing project, with children tasks, or else you can create a button which will import a standard set of task from a template project into the Project you are on when you click to import.  If you have more than 1 kind of standard projects, then create say two standard template projects.  When you put the buttons(s) on the form, I suggest making a summary field to count the # of children and hide the button(s) once the Project has children tasks or your user may click twice and double import. 

Set the Permissions so no one but the Admin can add or delete either the Template Projects (say have a flag field on the Project to indicate it is a Template Project) and also not allowed to edit Template children. 

The wizard to create the button for you is located in Settings (for the app), then App Management, then look for Copy Master Detail.  The wizard will guide you though making the button(s).



​

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • JoshuaCase's avatar
    JoshuaCase
    Qrew Cadet
    6 years ago
    Was getting an error when using this method because of some loop...

    I believe its because of the tables in this app or connected in a lot of ways.  Also, this is a very old app and needs to be cleaned up!  Yayy me!  

    I fixed my code though based on an answer you provided to someone else using the Var text method.  My error was not including the redirect to the current project I want to load tasks to as var text three and then linking them together at the end.  Works and I am off to set this up and run with it.  

    Thank you!

    ------------------------------
    Joshua Case
    ------------------------------
  • JoshuaCase's avatar
    JoshuaCase
    Qrew Cadet
    6 years ago
    Mark,

    I have run into an issue now of course.  How do I tie my code past the third line?

    Currently, I have:

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

    I get an error and only 3 tasks get created.  I assume I am missing the correct redirect pattern but I can't figure it out.  Am I limited to only 3?

    ------------------------------
    Joshua Case
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      Here is the generic format for up to 7 redirects.  Slice off as much of the salami as you need.  I have no idea why the nesting of the URLEncoding is required, but it just is.

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

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • JoshuaCase's avatar
        JoshuaCase
        Qrew Cadet
        6 years ago
        Thank you!!

        ------------------------------
        Joshua Case
        ------------------------------