Sync from App > Google Sheet consistently fails

I've watched the videos and read the posts and still can't find why my app keeps failing. So, hoping to find some help here. 

My app is pretty basic for the most part and the section that is failing seems like it should actually be very fast. 

Info:

  • Using Google Sheets for data
    • The worksheet in question has ~ 20 rows or less and ~10 columns (trimmed).
    • There is a script that updates the worksheet from an external source but the data is static in between so this shouldn't be an issue.
    • If I update data in the sheet it syncs seamlessly to the App
  • Table in AppSheet
    • There are 4 Virtual Columns. 3 calculate the sum of 3 of the worksheet columns and 1 calculates the sum of 2 columns and then divides them. 
    • There is only 1 editable field per row
    • The Failure happens when upating this single field whether it is just in one row or a few. 

Here are screenshots of the only data I'm getting from an error standpoint. The top image is what you see when selecting the binocular icon in the error report. These errors are "Preview" = true but it also happens in the live (deployed) app. 

Any thoughts or ideas would be greatly appreciated. I'm sure I've done something wrong somewhere, I just can't see it yet. 

Screenshot 2022-10-29 2.24.04 PM.pngScreenshot 2022-10-29 2.24.15 PM.png

0 16 398
16 REPLIES 16
Top Labels in this Space