Approval System - Multiple Entry Updates

[alex]

Hello,

 

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,

 

Alex

[svitlanataran]

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.