combine 2 tables for one submission form

[Medron]

I have 2 large tables used for submission datapagess of large amounts of client information. Now my company wants to combine the elements of the 2 tables into a single submission DataPage. I will likely break the new submission form to multiple DataPages for easier user experience, but I am not sure how to combine the two tables for a single submission form. Views does not seem to be the answer for this.

[TsiBiRu]

Hi @Medron,

I believe I found a post that is similar to what you are trying to achieve, Kindly check the link below 
 

 

Hope this helps

Regards,

TsiBiRu 

[Medron]

Thank you

[DefinitelyNot31337]

Hi Medron,

 

You may try implementing a multi-step submission form (as documented here: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-a-multi-page-form/).

 

You may also try creating another table to hold all the fields from your 2 tables, use the new table as the DataSource of your submission form(s), then create a Trigger to insert/edit data to your original tables.

 

Documentation about triggers here => https://howto.caspio.com/tables-and-views/triggered-actions/

 

Hope this helps.

-DN31337