create multiple child records on saving a parent record

Question

Hi,I want to create multiple records in child table on saving a record in parent table. I am trying to achieve these 2 things:1. The number of records to be created in the child table are based on a field in a parent table.2. I want to create these records automatically on saving the parent record. I do not wish to create a separate button/link on the form. Is there a way to embed javascript directly on the form without having to display a button?Any help is appreciated.&nbsp;Thank you in advance.&nbsp;

quickbasecoachd · Answer

If you do not find a better solution and don't have anyone to write javascript for you, then there is an add on product from Juiced called Triggers which can be used. It's at the bottom of the page.
http://www.juicedtech.com/add-ons

I also know how to do this with a Webhook, but not for the aspect of a variable number of records to be created. I had to do that myself recently, and while my solution worked, it was not very elegant.

What is the range of the number of child records which might need to be created.

angelangel · Answer

If I do decide to write the Javascript as a Code Page on my own, how do I embed it in the form?

quickbasecoachd · Answer

We will need to have someone else chime into that thread to answer that question, but I suspect that you answer is here.
https://community.quickbase.com/quickbase/topics/how-do-i-setup-the-image-onload-technique-iol

angelangel · Answer

I have never used the Image Onload technique myself, but based on my understanding it s used when we want to invoke a js on form load.&nbsp;

quickbasecoachd · Answer

Indeed. &nbsp;Sounds like what you are wanting to do.

Forum Discussion

create multiple child records on saving a parent record

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

create pipeline to create new records based on current record

Add button to create record in different app

Modify multiple rows within the same group using Single Record ?