Jump to content
  • 0

Approval System - Multiple Entry Updates





So in my application companies have a live profile, they are given a form where they can change this profile, but before it goes live we approve it internally. 


I've created a "session" table of each table associated with a company. When the company fills out a form it saves to the session table. When we approve it, it updates the live table.


Companies can have multiple contacts, stored in one table with multiple entries per company, each with a unique contact id and the associated company id. 


Would there be a way to update multiple contacts in the live table at once?


Thank you,



Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi Alex,


Can you please clarify, what exactly you would like to update? Could you please give an example?


You could create a report Datapage with a grid edit feature.


Also probably "find and replace" option would be useful for you. Find more info here


Another option is to create relationships with "Cascade update related fields". Find info at:  http://howto.caspio.com/tables-and-views/relationships/


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.

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.

  • Create New...