Jump to content
  • 0

Submitting into 2 or more tables at one time


jpraymond
 Share

Question

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!

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 0

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...