Fill and update data for 1 table from 2 other tables

[leecoong]

In the App sheet, from 2 tables RECEIPTS and PAYMENTS have the same structure, how to enter data on RECEIPTS table and PAYMENTS table, all data is poured into DATA table?. DATA table also has the same structure, everything Changes to data on the RECEIPTS and PAYMENTS tables are automatically updated in the DATA table. (Do not use the formula on GGS).

[TeeSee1 · Accepted solution]

If you want to simply add a row to DATA as you add a row to RECEIPS or PAYMENTS, you can create an action of type "Data: add a new row to another table using values from this row" to both tables and fire them either by a bot or as a form save event.

If you also want to update existing rows as rows in RECEIPS and PAYAMENTS are updated, then it becomes more complex. There could be a few approaches to accomplish this but that would really depend on your use case.

[leecoong]

Thank you for answering my question. I abandoned this idea because it was too complicated.