Jump to content
  • 0

Can you update multiple rows to a table from one datapage?


hollberg
 Share

Question

I'm working on an online ordering system, and I want to allow customers to order an arbitrary number of unique items in each order. Because I need to capture the SKU, quantity and price charged for each item, I need to be able to create a new row in an an \"Order_Details\" table for EACH item in the order.

Is there a way to post multiple new rows to a database table from a single webform datapage? I know I could redirect them back to an identical webform datapage after each submission to have them enter the next item, but I'd really like to have them enter all items on one page at the same time.

Thanks for any advice or suggestions on how to implement this.

Mitch

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi @hollberg,

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 create and execute a specified data events (i.e. insert, update or delete) to perform additional data changes and complex data calculations on the same table and other tables.

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...