I’ve got a list of items,each with his own URL obviously. I’ve done a QR code for each item. Few days later after I added items to the list all the qr codes was showing different items like the URL’s have changed. I understand that I will have to add elements in the bottom of the list not in the middle of it in order for all URL’s to stay the same(wich is not really a good solution for me) but even so what about when i delete items from the middle of the list? Can someone have a solution for this. Will row id help with something?
kind regards
Are you actually moving rows by copying and pasting? If so, you are probably breaking them away from their underlying Row ID, so yes, it’s going to break things. It’s like have 10 columns and only moving 9 of them. This would not be a problem if you delete rows.
This brings up the question…why do you feel the need to insert rows in the middle of a table instead of the end?
1 Like
thank you for your answer. i have a list of items categorized by type in a google sheet. every week i have to add new ones or delete some from a specific category.
Right, but why do you need to insert rows in the middle of the table? There are plenty of ways to sort the data on the front end of the app, so the order of rows in a table should be irrelevant in most cases.
Yes, adding a Row ID column should help, because it will expose it in your google sheet, forcing you to move the row id along with the rest of the data. But personally, I feel like you could be making extra work for yourself when adjusting the sort order of a collection may be sufficient.
3 Likes
The reason behind all this is that the google sheet is the only file that the client will have and he will be in control of adding or deleting his items, it will be his dashboard so a form of sorting the items will be necessary in the back end. I’m not really worried about the front end because yes, they can be sorted the way I want but the problem is the back end, the google sheet. Even a mistake done by the client will have a domino effect and will messed up all the URL’s for the whole items list.
PS. I appreciated your help 
That all begs the question - if the client is only working in the Google Sheet, what is the point of even connecting it to Glide? 
1 Like
that is a list of items on a construction site, the Manager add or delete items in his google sheet. on every item from that list will be added a qr code for every person on that construction site to scan it and see relevant information such as serial number, certificate, expiring date, safety inspection, etc.
this is one of the functions of the app, displaying info about each item in that google sheet list
Okay.
Well, as Jeff mentioned, adding a RowID will probably help.
I think what I would do is build a nice slick interface in Glide and show the client how much easier it is than messing around with a Google Sheet 
3 Likes