Data rows disappearing from Google Sheets database and unwanted values appear in the columns.

[Kamil369]

Hi,

I have a problem with AppSheet and Google Sheets database connected to it.

Once in a while, without any reason some data rows just vanish from my database in Google Sheets.
I didn't make any script in Script App, nor any automation in AppSheet, but yet I'm losing some data and I can even track the moments in Google Sheets history, but I don't know what is the reason.

App is being used on 6 different tablets - could that be a reason for that?

Another problem that occurs is that once in a while, after making any changes in one table, in the column where the user may put only numbers a value "N" appears. I've checked everything in the automation, but can't find anything which would make those changes. I didn't even make anything responsible for that kind of changes.

I would be really grateful if someone could explain what can I do with it, or even how can I diagnose the issue.

Sincerely, Kamil

[Steve]

Is anyone or anything other than the app itself using the spreadsheet?

[Kamil369]

Google Apps Script is using the spreadsheet as well to save/load the data, as not everything can be fixed from the level of the app (automation is pretty primitive compare to the scripts).

I started to think maybe the data doesn't disappear, but instead it is overwriten while the script pastes the records. I didn't check it yet, but I'm hoping my scripting was incorrect rather than the app structure in this case.

[scott192]

Have you updated the schema of your sheet recently?  Moved a column to the left or right....deleted or added a column?

You may have done this, regenerated the schema in your app and pushed out the update...however, unless every one of your tablets has received the newly updated schema then it is possible that one or more of them are trying to create rows with an out of date schema.

[Kamil369]

Thank you for the response. I didn't know about it and it seems that might be the problem, as I did actually change the schema a couple of times, but didn't refresh the current state of the app on tablets at all. 

[James_McFarlane]

Check that the Key columns are correct and that their data type is also correct. It happened that regenerated a table the key column was changed to number instead of text and that causing the rows to disappear.

[Steve]

---

@Kamil369 wrote:

Google Apps Script is using the spreadsheet as well to save/load the data,

---

That's where your problem is, then.