I transferred my app to my google workspace account and instead of sharing the Google Sheet with my workspace account I went to just select it again in Appsheet data sources. Then I started to get this error below (even though the rows are the same) and when I try to regenerate the table the page just hangs. I’ve tried to copy the app, go back to previous versions, go back to prototype, go into recovery mode and nothing changes the errors.
I’ve contacted Appsheet support but it takes 24 hours for Appsheet to respond to me and it’s always in the middle of the night (I’m MST) and they’re not digging into the problem. They’re just telling me to regenerate the column which doesn’t work. Usually they’re so good with support.
Has anyone seen this problem before? I’m in a panic because nothing is working and the business is at a standstill!
More than likely the app is referencing a different sheet than you think it is. Use the problem app to open the data source - i.e. in the app go to the Table, tap the “3 dot” menu and then click on “View data source” option.
When the sheet opens, navigate to the tab that is indicated in the AppSheet table configuration (see image below)
Thanks for your reply! When I click on “View source” or “View Data”
It opens up the right Google Sheet and all the rows are correct.
What’s weird is under tables it shows all these “Add Table…” options which usually happens if your sheet has a tab that isn’t added to your app but I have all the tables added.
The “View Data Source” listed at the top of the Table configuration does not navigate to the same place. See the image below and top on that menu option. It should open the specific sheet being referenced then you need to find the tab fo rthe problem table.
And you have confirmed the Table configuration in AppSheet, as indicated by the “Worksheet Name/Qualifier” property, is referencing the SAME tab you are expecting?
I presume you have tried regenerating?
Double check the DocID in AppSheet versus the sheet you are looking at. You can find the referenced DocID just below the “Worksheet Name/Qualifier” on the Table Settings dialog.
Is it important that you do not assume which sheet and tab and then MANUALLY navigate to it. Allow the linking in AppSheet to take you there. There have been so many people over the years make that assumption only to realize, after hours and even days, in the end they were manually opening a sheet NOT referenced by the app.
This is the Worksheet Name/Qualifier which matches my sheet name and pulls up the right sheet when I view source.
When I try to regenerate it just hangs and does nothing.
The docID matches…
I’m clicking the “View Source” directly from within AppSheet.
I created a new blank app and attached to the data source and everything is exactly the same and no errors so there is some sort of disconnect in my original app that I can’t figure out!
I would try creating a copy of that tab in a separate sheet. Then UPDATE the table to point to the sheet copy and see if that at least corrects the schema problem. If it does then try switching back to the original sheet.
Ok, so I created a totally new Google Sheet and recreated the tab/table and then added it as a data source and tried to regenerate the table and I STILL get the error and it just hangs during the “Regenerate Structure” operation.
So I created a whole new blank app and added the original google sheet and updated it and no errors connecting so there is something with the existing app and connected to ANY data structure as best as I can tell!
EDITED: Hold on, are you saying you added the copy as a second NEW table or were you attempting to update the source of the original table?
Well, the only other thing I can suggest is to add the table a second time with a slightly different name, find all the places you reference the original table and update them to the New second table. Once done with that, remove the original table.
FYI, you can pull up the app documentation and search it to find all table references throughout the app.
I created a new blank application and then pointed to my original google sheet and it works.
So, I then went and added a new tab in my original sheet and tried to add it to my original app and it doesn’t see it so I have NO idea why that would be!
OMG, I figured out the problem. ALL my tables were defaulted to the Worksheet Name of AdminContactInfo! So while, that actual ‘AdminContactInfo’ table was correct, every other one was incorrect so the error message was making me look at that one table when it was all the other ones that had the issue. Ugh! Thank you for working through it with me!
