Hello guys,
so I am building a new app at the moment, only using Glide Tables due to AirTable Sync Problems in my previous apps.
2days ago I noticed, that some row are missing completely, some times only a few columns are suddenly empty. This is a huge problem. Does someone have similiar problems in the past? Do you guys think it is always important to have synced tables from google oder airtable? And if yes, which do you prefer?
Thank you
Which plan are you on? Is it a legacy plan? How many rows of data do you have?
Hello, thanks for your reply. I recently switched to the business plan, after that I created this new app with only glide tables. I have 600 rows at the moment over all apps.
Should be fine then. The reason I asked is because legacy free apps only allow for 500 rows, which will cause rows to disappear, but since you are on a business plan, that shouldn’t be the case.
I’ve never heard of data randomly disappearing in Glide Tables. Are you using user specific columns by any chance? Do you have any screenshots showing a table where you have this problem?
Thanks for your reply.
I have like 10 computed columns, 3 columns as row owners and no user specific column. Everything within the app is german, so I think the screenshot will not help us xD
I also asked the glide support, but I didnt get a response. So I am now wondering if it is a good idea to use only glide tables. Do you have an opinion on this? Do you think it is a safe way to create the app? Around 50 users are going to use it as a warehouse management tool. If there are risks that product data, orders or warehouse stock is randomly missing… i will have a really big problem…
I can translate screenshots very easily regardless of language, but if you don’t want to share, that’s fine. I’m mainly concerned about seeing the column headings and if there are rows that exist, but appear empty. Screenshots reveal a lot more than you may realize. Even in the context of the screen outside of just the data table. There are all kinds of clues in a screenshot. All the little icons and colors reveal a lot of information.
My main app is based on google sheets, but that’s only because it was built in 2019 before glide tables existed, it contains some functionality that can only be achieved in a google sheet (which I have eliminated in a new version of my app that I’m working on), and I have some back end scripting that performs weekly backups and daily archiving of my data. I don’t trust Glide tables any less than Google sheets. In some ways glide tables are superior, because you didn’t have any additional sync issues. I only use Google sheets because I have additional requirements and some well established data.
I believe most of the experts only build with Glide Tables and Big Tables these days. They may also use external sources like big query, or SQL data sources, but I don’t think a lot of them use Google sheets, and Airtable is so restrictive that many don’t even bother with that. I don’t see any risks in using Glide tables to be honest.
Like I said, I’ve never heard of data randomly going missing. Usually any data that goes missing is either due to errors in app design or a plan exceeding their limits. I’m guessing there is some other issue going on here, but it’s hard to say without more information.
Thank you so much for reply.
Yes It originally thought, its better to stop using gsheet or airtable.
So here are some screenshots from the structure. There is the user table with row owner from the customer, our team (admin) and the agency control (for the customer who have an agency which is running their logistics operation). The goal is to have a secure way of showing the admins everything, the customer only their stuff, and the agency only their customers stuff. The agencies most times have more than 1 customer.
UsersTable:
The articles screenshots shows all details from the products and have a relation to some inbound (wareneingang) shipments into the warehouse.
Articles (Artikel) Table:
The wareneingang table has alle the details when somebody wants to send articles to the warehouse. And therefore the table movements (warenbewegungen) is related to wareneingang, where the articles can be chosen by the customer or agency which are within the wareneingang. If hope this makes sense…
Inbound Shipments (Wareneingang) Table:
Movements (Warenbewegungen) Table:
And some articles are gone, and some fields from some columns within wareneingang are now gone, too.
Do you see some problems with this setup?
I assume the Customer, Admin and Agency columns contain either emails or roles? Just to be clear, you don’t even see the data in the data editor?
Is there any chance that you have a Delete Row action somewhere in your app? You could probably choose any column in one of those tables, select Find All Uses, and double check if you have any actions that would delete a row.
Customer is always the mail, the admin and agency is a role. I see data in the editor 
But i can not send it here
I dont have any delete row actions. But I am going to add them in a while.
If you can see the data, then it’s not missing. That just means you either have Row Owners, Roles, or filters misconfigured. Do you have your user profile configuration set to point to a role column in the user table?
No no sorry, then I misunderstood your question.
I thought you wanted to know if everything is missing. But no, I see the most of the data in the editor, but the rows, which are missing, are missing in the editor, too.
Not sure what could be happening. You may have to continue with glide support. Be sure to check your spam folder. Sometimes glide asks followup questions on the ticket, but they never get a response back. In a lot of those cases, the followup email was sent to the users spam folder. We are also coming out of a weekend, so maybe nobody was looking at it the last couple of days.
