Dear AppSheet wizards,
I’m re-posting this from a separate comment.
I’m trying to create partitions for an app based on a Google workbook (Google sheet file with many tabs). My app backend consists of several sheets/tabs referencing each other in various ways, in some cases going down 2-3 levels from a parent table. What I’m wanting to do is create partitions that preserve the entire app schema (all the relationships etc) over a set time interval. Is this possible? Do I need to partition every sheet? And will the app behave the same way; for instance if I create a new record in a partitioned parent table will it also create the related records in the partitioned child tables? Lastly, if it is possible, how do I set up the partitions on the related tables so they continue to interact in the same way as the original schema?