Workaround needed? - AppSheet Q&A - Google Developer forums = 40rem)" rel="stylesheet" data-target="discourse-ai_desktop" /> = 40rem)" rel="stylesheet" data-target="discourse-gamification_desktop" /> = 40rem)" rel="stylesheet" data-target="discourse-reactions_desktop" /> = 40rem)" rel="stylesheet" data-target="poll_desktop" /> Workaround needed? AppSheet AppSheet Q&A errors Sherin_Premkumar August 11, 2026, 6:39pm 1 Because of the sync issue last week …the data was not written to the database immediately and it was showing the red exclamation mark in the frontend. One of the user did not notice the error till now for a week and the data kept accumulating in the frontend. Now when I clicked discard changes (after asking the user), obviously the data was not there. Are there any workaround for this? this has happened already and I genuinely cannot think of any way. I understand users cannot enter the data when it shows an red exclamation mark but I need a workaround that prevents users from entering any more data in the frontend even when the error is there. Jose_Arteaga August 11, 2026, 7:23pm 2 Hello @Sherin_Premkumar, I sincerely apologize for the inconvenience I did some research and I found this post: Way to remind users about unsynced entries Aleksi explains a possible solution there. Sherin_Premkumar August 11, 2026, 7:38pm 3 Hello Jose , thanks for replying! But that is not the solution. “You’ll need to reset the chances and all edits will be lost this is the only way I know you can make this app sync again.” I do know how to make the app sync again but I do not want the data (adds/updates) to be lost. Not sure who marked it as a solution! Sherin_Premkumar August 11, 2026, 8:14pm 4 “And then add an event action to your other tables (form view) to trigger a warning pop-up if the difference is more than for example 30 days.” Jose, I have 1000s of records out of which let us say 100 would be actively being edited(updated). it is not possible to guess which records would be updated and which one wont be. If there is an error , it should not let the users create or update anything in the frontend! Jose_Arteaga August 11, 2026, 10:23pm 5 I understand. My best suggestion at this point is to reach out to support to see if there is a way to recover all this information for you. I don’t think this is goig to be your case but it is important to mention that AppSheet support is not available for free accounts. If you have a license then please follow the steps below: Go to Appsheet help Scroll down to the bottom, you will find a box with the following text Need more help? Try these next steps: Contact us Tell us more and we’ll help you get there At this point you will be redirected to a three steps process in which users will possibly find answers to the query they have. Click Next Click Next Step Specify your preferred language and either click on Chat or e-mail JuneCorpuz August 12, 2026, 12:43am 6 Hello! You can pause the app to prevent users from using the front end. CleanShot 2026-08-12 at 08.42.46@2x2350×1062 169 KB Denzil_Snyman August 12, 2026, 5:07am 8 Educating users is a prerequisite I use for clients that choose appsheet, knowing the offline behavior and importance thereof is vital in choosing whether enable offline use is allowed, then for desktop users, understanding that sync mechanism is vital. Even presenting that message as part of the onboarding screen with some clients. Offline and Sync: The Essentials - AppSheet Help Offline and Sync: The Essentials - AppSheet Help In a case whereby this occurs, recovery mode is available for mobile users however the system clearly indicates its not available in desktop mode (therefor critical for users to check their sync mechanism regularly) Screenshot_20260812_070553_com.android.chrome1080×2340 255 KB Steve August 12, 2026, 2:14pm 9 There is no built-in way to discover a sync failure or to prevent updates from accumulating. I’ve never addressed this problem myself, but you may be able to add a guard against it yourself. Virtual columns are only recomputed under the following situations: When the row it’s a part of changes. When a value it uses changes. When a sync occurs. If you create a table (called This App, e.g.) that has (at least) one row, that never changes, that has a virtual column (called Last Sync, e.g.) with the expression, NOW(), that virtual column value will only ever be recomputed when a sync occurs. You can then make decisions in the app based on how long it’s been since the last sync. For instance, you could make any table read-only if the app hasn’t synced in the last hour with an Are updates allowed expression like this: IF( OR( ISBLANK(ANY(This App[Last Sync])), ((NOW() - ANY(This App[Last Sync])) >= "001:00:00") ), "READ_ONLY", "ALL_CHANGES" ) Sherin_Premkumar August 13, 2026, 1:32pm 10 hello Steve , it would be very hard for me to track when each was synced and not synced and make a decision based on that. i have about 8 to 9 tables all with 2000+ rows and uses update about 100 rows frequently and add about 50 each week. how about enabling this? would I get a notification at least when users have a red exclamtion mark if I enable this? image584×393 17.4 KB Steve August 13, 2026, 1:53pm 11 You need only one table (with only one row, only one physical column, and only one virtual column) to track the last sync time of the entire app. When the app syncs, all tables sync, so if you know the app synced, you know all tables have synced. You would not. Sync errors are client-side, audit errors are server-side. Sherin_Premkumar August 13, 2026, 2:19pm 12 oh got it, thank you! I will work on the above and get back to you soon! Sherin_Premkumar August 13, 2026, 2:21pm 13 thank you, JuneCorpuz. I just don’t want to pause the app just because one user did not notice the error. Most of them do notice. Just a very few of them don’t. Sherin_Premkumar August 17, 2026, 2:11pm 14 This is a nice workaround. thanks, Steve!