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

Question

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 the same for each project at project creation. I have a successful formula to make a single task related to the parent record in the task table but I want to have a button that creates multiple tasks as I set them up based on the template all related to the same project.

I believe I have to use the var text URLONE = ( approach but I don't know how to tie them together and have the page redirect back to the original page.

Working Code for Single Task Creation:
URLRoot() & "db/" & [_DBID_XXXX] &"?a=API_AddRecord&_fid_48="& URLEncode ([Project]) &
"&_fid_23="&URLEncode ("Custom Title") &
"&_fid_6= "&URLEncode ("Template Text") &
"&_fid_16="&URLEncode ("Template Text") &
"&_fid_67="&URLEncode (ToText("User Email"))&
"&_fid_13="&URLEncode ("Template Text")) &

"&rdr=" &

URLEncode(URLRoot() & "db/" & Dbid() &
"?a=dr&rid=" & [Project])

How do I make a single click create up to 13 tasks with different default assignments and text?

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

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community