Describe the bug:
After entering data using my app into Excel, the data shows in my app, but not in Excel. If I exit the app and go back in, the data is gone in Glide, but the Row ID is there in Excel.
Expected Behaviour:
The data should sync to Excel and stay in the app.
How to replicate:
Enter some data under “circuits” – a three-column table in a one-tab Excel spreadsheet, where only one column is required besides the Row ID.
Demonstration:
During the beta phase of Excel, I had an app where I spent the afternoon entering about 150 rows in an excel spreadsheet which was attached to an app. About half the rows ended up with columns of missing data (the rows were still there).
I submitted that, but Glide’s tech team was unable to find anything conclusive.
Since this test app and table is so simple, and it can be reproduced at will, hopefully it will provide a better example of what is going on with Excel.
I just copied the app to a new app, and of course Glide converted the Excel Table to a Glide Table. That was expected. I tried the same thing using the new app and the data stays in place (also expected).
No unfortunately this has not been Addressed. I have not seen a resolution to the problem. I have seen several people report similar issues. Not sure if they know what’s going on
Since the last time we talked about this issue, it happened once again to me and we have to connect the table again. I’m not sure if they deployed a fix or not but it has been stable for the last 2 weeks.
Noticed you on this thread. I have recently had this happen whenever I added new columns to an excel table. After syncing the column shows up but I am unable to save data entered in Glide to the new Excel columns. The data disappears in the Glide interface. All the original columns work fine.
Is the solution to disconnect and then reconnect the Excel table?
hat happens to all my screen builds?
@ThinhDinh says above that reconnecting the sheet solves the problem. I don’t know. I had an App that reliably reproduced the issue, but I gave up fighting the Excel problems and have not tried in a while. I also have never tried using a new App. I have only tried it with Classic Apps – although I am not certain that would make a difference, since it’s the data editor which both types of Apps have in common.
I wouldn’t try that, these days I asked what would happen if the glide lost synchronization with my excel, in a microsoft user password change for example, nobody knew how to answer me. So, I have the impression that tables in the glide environment would turn into native glide tables.
By re-connecting the table, I had to configure all my computed columns again so it was not very pleasing. My data is read-only, so I’m not sure about not being able to enter data from Glide to Excel. Probably worth a support ticket.
Another question for @GrumpyRick though, if you change the data via the data view instead of a component on the front end, does it work?
In my experience, it doesn’t matter whether it’s through the data view or through a form. In the dat view, you could literally sit there and watch the fields disappear.
Answer to your question is no…there was no difference.
My client went ahead and created a new table with all the needed fields. I then had to recreate all the calculation fields and updates al; screens, forms, and actions using the new table. Took all evening but no it works .
Hope they do not need a new field down the road.
For your problem, it was enough to delete the column with the problem and create a new one, as I had suggested in another topic, this bug does not happen in every new column that you need to create, it is something that rarely happens.