Data disappearing

[Resound_FB]

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.

[Qiro]

This isn't an issue I have ever encountered myself, but it may be worth setting a backup with an App Script so you can pinpoint when it's happening?

It is possible that it's some kind of syncing issue, I suppose, but without seeing what's going on it is really difficult to say.

[Steve]

When a column value is changed in a row, the entire row--including the new column value and the old values of other columns--is written to the data source (the spreadsheet). If two users both update the same row at around the same time, the second user's update will overwrite the first user's.

[Lindsey_Lindow]

I am experiencing the same type of issue and am wondering if you figured it out?

[Joms]

I am also experiencing some weird bugs I guess. The data encoded is there for the mean time then suddenly disappears with no numbers on the sync button.

[mikas]

 I had the same problem and found my solution on another forum:

Right-click on one of those blank cells and select View Cell History. Are you marked as the person that made the change? (Even though you didn't manually edit the cell.)

Is this only happening in the RYG column or is it in random cells in your sheet? If it's randomly occurring and you see that you're being logged in the cell history as the person that made the changes, then a Chrome extension, a third party app, or your computer equipment may be causing the random deletions. We've heard that Logitech equipment can sometimes cause this, as well as third party apps that mimic keystrokes like Caffeine.

If so, are there formulas in your RYG column that could be returning a blank value?

If none of the above, are there cell links in the RYG column? (You'll see a grey or blue arrow in the cell if it's cell linked.) If you see cell links, then the changes are coming from a different sheet. Details on cell links here.

I use Caffeine so that was my problem 🙂