If changes are 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
- 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.
If you are using Google Sheets:
- Do you have filters set on the sheet? There 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
If you are using Smartsheet:
- Does the column order in Smartsheet still match the column order in your AppSheet app definition. If there is a mismatch, AppSheet may not correctly find the row to make an update
- Do you have a column called 'Row ID' in your Smartsheet? Please remove this column. AppSheet utilizes a 'fake column' called Row ID in order to match to specific rows in Smartsheet. If you have such an explicit column, it messes up this comparison and causes updates to be skipped.
If some rows from the sheet are not visible in the app
If changes made in the app are correctly captured in the spreadsheet but are not shown in the app, the most common reason is the presence of a number of empty rows in the middle of the sheet.
If you are using Google sheets
- The presence of custom formatting might prevent 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.
if you are using Excel
- If the worksheet has nested tables, only the first nested table is read by AppSheet