I am progressing well developing an integrated app to manage our business but it means I am now up to 12 tables (Google Sheets in a Google Workbook. Some of them are for data lookups (e.g. Workers, Materials OrderTypes etc) and others are in Parent/Child relationships. Every time an Order is added a record is created in the Orders table. From there several jobs are created and linked to the Order. Then I have several more Timesheet entries linked to each job, as well as Materials used in that table, and Data Sheets Issued in another table.
If I implement this App, all these tables will fill up very quickly and I will need to empty out closed Orders and all the associated records - ideally copy them to another workbook for historical records. Is that best done in AppSheet somehow and, if so, how? Or do I need to write a Google Script that will find all the linked records and delete them when I delete an order?