Comments Jump from one topic to another; paid app

[Mark]

This definitely looks odd. I’ll look into it.

[Mark]

Just to make sure I understand this correctly:

1. Glide adds the row, which results in

2. Your script sorts the rows, resulting in

3. Somehow the Row ID column is overwritten with what it was before step 2, resulting in

Is my understanding correct?

[Naos_Wilbrink]

Yes 100% correct.
I also have a sheet / test setup if you need it.

[Naos_Wilbrink]

@Jeff_Hager I really appreciate your extensive reply.

@Jeff_Hager

Re-sorting might be fine on a daily/week/monthly basis for database maintenance, but continuously like that would make me nervous, no matter the case.

You are right for it not being an actual solution, it already was a bandaid. Trying to cut a corner.
I did de-activate the sorting. And I removed some functionality.
I’ll find a new way of moving fwd.

@Jeff_Hager

I watched your video yesterday, but it went really fast to track and follow everything that was happening.

Mark was able to sum up the finding quite eloquently and very much to the point.

@Jeff_Hager

I will say that one time I was testing someone’s app with them. I believe it was a private chat feature in the app. At one point they deleted or reshuffled the rows and I ended up in a different chat, so I believe it’s possible for something weird to happen if you are mucking around with the data.

This would be relevant for @Mark too! Data integrity is the most important foundation.

[Mark]

I’d love to see the test setup!

[Jeff_Hager]

Ok, now I see it with Mark’s screenshots. It was hard for me to track that in the video when watching on my phone. I tried to watch the row IDs, but with so much happening at once, I missed the point that the row id switched on all rows. I’m wondering if it’s an issue with glide and Google making changes at the same time. I used to have an issue with some very heavy sheet calculations and queries that would take several minutes to run. As the sheet was calculating, Google wouldn’t accept any new data from Glide. If a resync happened in that timeframe, then new data was completely lost and removed from the app. I’ve since solved it by offloading the sheets with most of the heavy formulas to a completely separate Google spreadsheet using import range, let that do the hard work, then pull in the resulting data back into the main spreadsheet using import range. That solved a lot of sync issues for me. I’ve been slowly switching to Glide only functionality where I can and I only have a couple of things to solve to fully eliminate the separate spreadsheet. The rest is lightning fast within Glide.

[Naos_Wilbrink]

The copy I made of the app is: https://1qf2d.glideapp.io/
I’ll share the sheet https://docs.google.com/spreadsheets/d/1McyFiFiU_17zCieuh_ZgyFCQXgYBTppKv1_0l92HXmk/edit?usp=sharing
You can request access and look into the Script editor.