I see errors being logged several times a day for "Range ('Temp Sheet'!A59) exceeds grid limits. Max rows: 42, max columns: 26" or something similar. It appears that AppSheet is trying to add\edit a row in the Temp Sheet and it's providing an invalid row number. The row that is being referenced changes from error to error. I think this is caused by the script deleting rows from Temp Sheet every 10 minutes. The app isn't aware that rows are missing because the app's cached version of the sheet has more rows than the current version. This could be contributing to row's not being added and files not being recorded in the sheet. how to permanently avoid this issue ?
LinkedIn
Twitter
