Hi all,
I have my app set up to not automatically sync data (as the auto-sync seems to be causing some issues with some quickchart charts in my dashboard… but that’s a different matter).
I have two main pages in my app;
- a dashboard view with filters that affect a displayed slice and some quickchart charts
- a list view where users add and update row items
Having auto-sync off works fine on the dashboard and everything still updates as expected.
For the list view, I have created a action so that on form submit an app sync is forced by using LINKTOVIEW(“xyz”)&“&at=”&(NOW()+1)
Generally this works well - until someone makes loads of changes in the dashboard and then adds or updates something in the other view. The user then sits at a sync screen that slowly works through 20+ changes.
Is there any way that I could automatically discard local changes/reset changes when navigating away from the dashboard view, or with an action? With this I could make sure that unimportant changes in the backlog are cleared out before and important changes are made.
I would love to ‘solve’ this issue by moving my data away from a Sheets file to an Appsheet database for nice, speedy syncs, but currently our Enterprise account manager has not enabled this feature for us.