We have run into a show stopper problem with Glide. It has harmed our business, our reputation, and client trust, and caused a lot of work for us. I will explain it here a) as a warning to everyone in case you have not come across it yet, and b) in the hope that someone has come across it and has an idea of what to do.
When users are submitting forms - Glide is sporadically creating duplicate rows in our sheet, sometimes as many as four additional rows, with identical timestamp (to the millisecond), and identical unique id’s, and all other fields the same. Based on how we use the data downstream it has cause a large problem for us, glide is one part of a larger ecosystem we have built.
Glide response so far
Glide engineering say they are ‘confident’ it is googles fault, i think they believe something like: google thinks it did not write, and sends a false positive failure to Glide, glide tries to write it again, but it is actually already there. Hence the multiple rows. Glide said they will file a bug report, but said they don’t know if they will get a response, or if it will be addressed. They have suggested our options are:
- Wait and hope google comes back with a fix.
- If option (1) is not suitable for us > leave the platform (presumably to find an alternative solution that works)
Where we stand now
Glide have suggested some hacks to work around the duplicate content, but they are complicated and painful for us, vs having the product (Glide) work as described. We have something in place for now, but it is not a long term solution, unless this is resolved fast we have to go with (2) which is a huge pain for us, as we have already invested effort in utilizing Glide - assuming it is a robust solution. So it’s double work, and at a time when we cannot easily afford to build out for something different.
Background on our use case
Some other key points, in case it helps anyone trying to help us troubleshoot it
- we have several apps, all feeding the same file
- the data is over 10k rows.
- the problem only started around early Nov as far as I can tell
- we have been receiving this error message, but were told ‘don’t worry about it’ by glide. It did predate this problem, so it may not be connected, but mentioning it just in case.
Glide cannot load data from your spreadsheet. It’s not clear what the cause of this issue is. If it persists, please get in touch with us
Thanks to the community in advance, and best of luck, and I suggest keep an eye on this closely in your own apps, especially if duplicate rows would also cause you a problem