Submitting into 2 or more tables at one time

[jpraymond]

I'm new to Caspio and loving it. I just finished perusing all of the pages of this forum looking for topics discussing the entry of information into multiple, related tables in one submit on a web page.

I would like to be able to collect information through one screen, and the information would exist across 2 or more tables. I am building an application for mechanics to manage job information. One of the pages would allow the mechanic to enter vehicle and customer information that would exist in the VehicleJob table, and at the same time special notes about the job would be entered and would exist in a SpecialModifications table. There could be a one to many relationship between the vehicle job entry and the special notes (the many), therefore I need to keep the notes in a separate table. How can I accomplish this in one web page? Thanks for the help ahead of time!

[bahar_vm]

Hi,

As you know each Caspio Web Form could only be linked to one table, so one solution that I can think of is to have the Web Form linked to the VehicleJob table then after submission, user is directed to another Web Form which is linked to the SpecialModifications table. The first Web Form will pass the Unique ID of the VehicleJob table to the next Web Form that should receive the ID. This could be done by Caspio passing parameters features, please see more information about passing parameter online at http://howto.caspio.com/parameters/pass ... ridge.html

http://howto.caspio.com/parameters/pass ... tring.html

Best,

Bahar M.

[Kurumi]

Hi @jpraymond,

As of July 27, 2017, Caspio introduced a beta feature of Triggered action which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-9-8/
And on October 4, 2017 Caspio released the version Caspio 9.9 that includes their new feature, Triggered Actions.

This allows you to save information on the same table and other tables at the same time. 

Check this video for more information:

 

For more information/tutorial about Triggers, you may check it here: https://howto.caspio.com/tables-and-views/triggered-actions/

I hope this helps!