Build A Submission Form (DataPage) That Writes to Separate Tables

[bbeshlian]

Hello,

I want to build a Submission Form (DataPage) that submits data to two separate tables. The tables are built and a one to many relationship is set. I built the and tested two separate submission forms and they work as I want them to. The first submission form pulls the Employee Information from a separate source and is written to and Employee Information table. The second submission form pulls some data from the same source as the Employee Information, this is for the case if the Employee made a referral, and writes the data input to a Bonus Data table. I've watched a couple of the help videos on setting up the relationship and passing the parameters. My Employee ID field is the parameter in plan to pass since its unique in the Employee Information table and can appear multiple times in the Bonus Data table. I've done some experimenting and I see a View will allow me to update one table or the other but not both at the same time. This is where I am stuck. I've attached screen shot of the Table Design, Relationship and Datapages. Let me know if more information is needed.

Thanks,

Bill

[cheonsa]

Hi @bbeshlian,

 

If you want to submit data from a single submission form to two separate tables, Triggered Action is what you need. 

 You may refer to these links for more information about Triggered Actions: https://howto.caspio.com/tables-and-views/triggered-actions/

 

 

Hope this helps.

 

-kristina

[TsiBiRu]

Hi @bbeshlian

I think you can use the solution provided in the forum post below.

I hope this helps.

Regards,

TsiBiRu

[bbeshlian]

Kristina,

I can see how a triggered action will work. However, how would I set up the submission form to collect the data then input it into the respective tables? I thought a DataPage will only allow me to work with one object like a View or Table at a time unless I have a parent/child relationship set and pass a parameter common to both tables.

Thanks,

Bill

[bbeshlian]

Hello Everyone,

Thanks for providing me with answers that got me to dig deeper into my question. Here is what I did. For the Employee Data Input when the Submit button is clicked you are sent to the Bonus Data input DataPage. Also while configuring the fields I selected on the Advanced tab to pass the Employee ID on exit. I attached screen shots.

Bill

[TsiBiRu]

Hi @bbeshlian

I've created a sample DataPages with the same workflow.

What I did is I added Virtual fields on my first submission form, to capture the Data that I will input to my second table on my second DataPage. And passed the value of these virtual fields as a parameter on exit. And set the  first DataPage to redirect to my second DataPage.

 

Then on my second DataPage, I've received the value of these virtual fields from my first submission DataPage. And assigned it to the respective fields on load.

After that, I've added an HTML block on use the code below to automatically submit our second submission form, once it successfully received the value from our first submission form

<script type="text/javascript">
  if(document.getElementById("caspioform")) {
  document.getElementById("caspioform").style.display = 'none';
  setTimeout('document.forms["caspioform"].submit()',1000); } 
</script>

I've also attached the exported copy of the sample DataPages that I've created, so that you will see how it works.

I hope this helps.

Regards,

TsiBiRu

CaspioData_2019-Mar-07_2257.zip