Hi,
I have an app in which we log a client's arrival time by pressing a "check in" button (action populates 'Check In' with TRUE and populates 'Arrival Time' with NOW()) . Randomly, data in both the TRUE cell, and the NOW() cell in Googlesheets will delete, reverting the cell to empty. I've looked at edit history for the cell, and it says my account has deleted the info, but no one is doing that, and the only way to do it accidentally is to click an "Undo Check In" button (which I added in case someone clicks the wrong client), but they would then have to take the step of confirming that they want to undo the check in.
It seems to happen completely randomly (just on random clients and at random times during the day, ie they may have been checked in an hour before, then suddenly the time and the TRUE disappear). I've also watched as on the spreadsheet as the cell data disappears.
I only use one sheet for data, but a few slices (Client Check In, Client Interview, Stock). The only one that has access to change the check in is the Client Check In View, but the others have the data fields to view (cannot edit in the other forms/detail views).
At a loss why the data is disappearing. Before using AppSheet, never had the data disappear from the GoogleSheet, so assuming it's something that the App is doing, and not a bug in GoogleSheets.
Any help will be appreciated.
LinkedIn
Twitter
