Question about syncing.
We’ll be using the app I’m working on to log passengers and cars boarding our ferry. The log data will get saved up to the spreadsheet when the ferry operator (delayed) syncs.
Over time that will add lots of great daily log data to our spreadsheet, which we can then use for a variety of purposes. That also means though that, over time, the ferry log data on the app side will also grow and grow and grow when we sync (right?) . That’s not really necessary.
I can always use slices to filter the rows that will be visible, but I don’t really want the app to bloat.
So the question: is there a way to prevent a table from being read into the app from the spreadsheet when syncing, while allowing data to be copied into that table on the spreadsheet? A one-way sync, in other words.
From reading the documentation on syncing that would not seem to be possible, but I’m asking just in case.
Editing and cleaning up the spreadsheet is of course an option, but that would add extra work for our office.
EDIT: Oops. I just realized that there would also need to be a way to clear the data for that table on the app side once that data is saved into the spreadsheet. So I don’t imagine any of this is possible…