How to Automatically Sync Data Between Multiple Tables in AppSheet?

[Gusttavo]

I'm facing a problem, and I'm not sure if it's possible to solve it in AppSheets; it might be asking too much of its capabilities...

(I'll explain my need with an example) I have three tables in my database: QUOTES, COMPOSITION, and ORIGINAL PRODUCTS. I intend to create a fourth table called GENERAL COMPOSITION.

All tables will have the same data layout (same columns, same data formats, etc.); the only difference is the concept of the information. Therefore, I need to keep the first three separate and the fourth table to unify everything.

Here's the problem: How can I, for example, create an item in the QUOTES table, and a copy of this data be sent to the GENERAL COMPOSITION table? Or: The data has already been created in the tables, and copies of this data have already been sent to the GENERAL COMPOSITION table, but I need to edit a piece of data in the ORIGINAL PRODUCTS table. How do I ensure that the same product, which was copied to the GENERAL COMPOSITION table, is updated in both tables to maintain data consistency? And finally: If I delete a piece of data in one table, how can I ensure that the same deleted data is removed from the GENERAL COMPOSITION table?

I'm not sure if this is an easy solution... But I confess that I haven't come close to finding a solution. Can you think of an idea to help me with this case?

[Steve]

This is what Automation and bots are for.