I have suddenly gotten this error. Cannot find it in any table or โฆanywhere.
Just shows the red โerrorโ dot next to โInfoโ โDataโ and the โColumnsโ tab of the โDataโ interface but Iโve opened and scanned every single row looking for the source of the error and I canโt find a single table row that is red with the error flag.
No clarity from support dbase. I canโt upload any new tables without getting an error when uploading that same error over and over.
WTF?
App is: QuoteBuilder-171176
Totally stuck. Been trying to figure it out for 30 minutes now. HELP!!!
It looks like a bug. We are investigating.
Work arounds didnโt help. Itโs a bug. Can I get an update?
@Todd_Stone The immediate cause of the issue is that a few of your tables (Contract Status Types, Cost Item Master List, and Contract Types) are not correctly associated with their column structure.
The root issue is probably something to do with renaming tables. Did you happen to rename any of those tables?
Iโm going to try to fix the root issue. In the mean time, as a workaround, could you please try removing those tables and then adding them back to your app? Let me know if you encounter any issues doing that.
@Todd_Stone Part of the bug has to do with adding two different worksheets that have the same name (e.g. Sheet1). As a further workaround, you might want to rename the sheets for the tables youโre re-adding to be distinct. Thanks.
I can do that BUT obviously that means Iโm going to reprogram all of the associated relationships. Iโm not understanding why the table restructure wont fix it and more importantly, why wonโt it tell me where the error is?
Iโm unclear as to why the name of the tab would be relevant. Same issue. Just about every tab I have in every google sheet is named the default โSheet1โ. Will changing the name of the tab break all the downstream relationships that are based on this worksheet.
I donโt understand why (unlike how it used to be) the table name default that appsheet places it into the system with is now the name of the tab, not the name of the worksheet or if necessary the name of the worksheet/tab?
Ok. Just tried deleting them and restarting the app. No, I didnโt re-import them because if the source of the problem was those tables, then deleting them should get rid of that error and instead give me a bunch of other errors based on the missing tables that are referencedโฆdidnโt happen. Same error. Theres a bug somewhere. Itโs REALLY frustrating to have an error that is racking up a bunch of my time and it shouldnโt be there and it wonโt give me any direction on how to solve it.
@Todd_Stone I believe Iโve found the root issue and put a fix in for it. It will need to go through our nightly tests before we deploy it. In the mean time, please try the suggestions I gave above to work around the issue.
Since I still have the error and deleting those tables didnโt help, can you provide some kind of an update?
Hi Todd. Youโre right, itโs a bug. Still trying to fix it.
The details: When you add a table (say, a table called Customers) it also gets a set of columns associated with it (called Customers_Columns). When you rename the table (say, from Customers to Clients), it keeps the same name for its columns (still Customers_Columns).
The bug happens if you then add another table called Customers (different than the original Customers table). Now both Clients and Customers are associated with Customers_Columns. I believe this is what happened with your app.
I put in a fix. But the fix introduced new errors that I still need to address. So Iโll still need some time to get this issue fixed completely.
In the mean time, can you roll back to an earlier version of your app that doesnโt have this issue? Then, when you add new tables, you can work around the issue by ensuring that the new tables you are adding do not have the same name as a previously renamed table.
It was a prototype app. I donโt have any older versions saved. Is there a rollback or restore feature or would I have needed to actually save a prior version?
You have to realize this is a pretty major bug if I can do something that actually โbreaksโ the app and the only fix is a reverting to a prior version (which Iโm thinking can only be done if I had the foresight to create backup versionsโฆwhich I did notโฆas I didnโt know that an irrevocable error could even take place.) Quite an issue for a program meant for โnon-developersโ.
I still see the error so it seems like what youโre telling me is I have to rebuild the app from the ground up in order to resolve this?
I have to say that REALLY sucks. Days of work lost.
@Todd_Stone
Have you checked Manage >> Versions >> Version History pane for older versions of the app? Because with each save in the app editor, a new version is created.
Thanks. Iโll try that.
Nope, only one version there. Iโm not sure what you mean by โeach saveโ because Iโve done like hundreds of โsavesโ on the app prior to the one that broke it.
Iโm assuming there is something I have to do to save a version, but I have no idea what that is.
Hi Todd, do you know the approximate date of the version you would like to restore? I can get it back for you. AppSheet keeps a version history for all apps, though the history window is limited based on plan type. However, if you give me a date I can restore it for you.
Iโm sorry that you got bitten by this bug. There should be no irrevocable errors in AppSheet, but occasionally we need to fix a bug like this one.
Also, why did you stop automatically naming the tables based on the names of the underlying name files? Since google wonโt let me create duplicate named files in the same folder, and all my source tables are in the same folder, then this issue would have been automatically avoided, wouldnโt it (unless I chose to name the table something else)?
I have the same issue with the error:
AppSheet Database is currently a preview feature and under active development. Preview features are not yet suitable for use in important apps. Until it has achieved greater stability, I recommend against using this preview feature except for testing and to help the AppSheet developers in their efforts. To follow the progress of and contribute to the development effort, please visit this dedicated Community topic:
I am showing an error (red X) but none of my columns in any of my tables have highlighted to find the error..... how do I find it?
I have the same error
I changed a table source gsheet with another optimized gsheet (with a different name and only one column) , and then I tried to regenerate column structure , and then I got the error. Reverting back to old source fixed it for now.
Also, while the error is active , my table is missing from the Columns tab.
โ
โedit : the regenerate columns button is also missing
Please contact AppSheet Support for help with this.
User | Count |
---|---|
36 | |
33 | |
28 | |
23 | |
18 |