Changes not captured in the spreadsheet
If changes made in the app do not appear to be recorded in the backend spreadsheet, here are some troubleshooting steps:
- Is the app being synced after the updates are made (in some cases, your app users may not know they should press Sync)
- Were there any errors reported during Sync?
- Check the app's Audit History to see if it shows that the changes were actually received and successfully applied
- If you are using Google Sheets, do you have filters set on the sheet? This is a bug in Google Sheets that causes updates to appear to succeed (but never actually get applied). Do not use spreadsheet filters --- instead use filter views if you are using Google Sheets
- Do you have a lot of empty rows in your sheet? If you have a hundred empty rows followed by a row with some text in it, AppSheet will insert new entries after that very last row. You may not see these rows because you may not be scrolling down your spreadsheet to find them. Please remove all empty rows in your sheet to avoid this situation.
- Do you use the RowNumber column as the key of your table? This is a bad idea and can lead to data being overwritten or the wrong row being updated.
Changes not captured in the app
If changes made in the app are correctly captured in the spreadsheet but are not shown in the app, it is likely that the spreadsheet contains custom formatting that prevents AppSheet from reading the entire spreadsheet.
One common type of sheet formatting that can cause problem is alternating colors. If you have an alternating colors formatting rule in your sheet, you need to ensure that the range of the rule applies to the entire sheet. For instance, if the range of the rule is "A1:F7", AppSheet will only recognize rows 1 to 7 and columns A to F as being part of the table. Any row beyond row 7 and any column beyond F will be ignored when AppSheet reads the sheet.
To fix this problem, you can change the range of the rule to "A:F", which includes all the rows in the sheet. If new columns are added to the sheet, you will need to modify rule accordingly to include the new column in the formatting rule.