Im trying to avoid adding a :lock: Row ID row that is built in. my google sheet is being queried from another google sheet, meaning that I can’t edit mess with the cells. and adding a row id from glide would mess it up. is there a way that i can assign my own column in google sheet to be a :lock: Ro…

Okay, I understand. So I assume that Glide only reads from that workbook and doesn’t write any data back to it, yes? If it was writing data back to the sheet, then that would break your import/query formulas. I guess the first question is - do you actually need a RowID column in that sheet? If you…

The native “:lock: Row ID” column in a Glide table has its own inner workings and I personally avoid messing with it. I don’t even rename the column anymore. I use it on just about every table, but I don’t play around with it. If you have your own ID column in Google Sheets, you could continue usin…

[image] nathanaelb: and your column will probably lack features that the native one offers under the hood. Most notably, User Specific Columns will not be available in any Google Sheet connected table that doesn’t have a Glide generated RowID.

when I edit the column in glide, it doesn’t give me the option to make it a :lock: Row ID, i must create one from glide page. But this will mess up my google sheet. I will have to find another way then. Thank you

Why will it mess up your Google Sheet? It will just add a column to the end of the sheet. That shouldn’t present a problem? :thinking:

Yeah I think about this the same way. If you structure your query the right way then it will just output the right number of columns. Adding a rowID to the end of it should not be a problem.

So here is the scenario. There are two workbooks. One is called “original inventory” and the other is called “copy of inventory” Now, generally, i don’t like to mess with the original inventory because it has a lot of formulas and a lot of columns too. and the way i add stuff to it is automatic fr…

thanks for your genuine feedback, I am working on a script right now for it to work. Like I said, its more of a google problem than glide. I do appreciate the suggestion, I have thought about them before, but they might not work with the plan I created. Thanks again

Cool. I’ve done this before (written Apps Script to keep sheets in sync), so if you need any help with that feel free to ask.

Thank you! i will keep you in mind if i get stuck

Hi there, i already have a uniqe ID column on my googlesheet, can i make that column as my 🔒 Row ID in glide

Ask for Help

Topic		Replies	Views
ROW IDs ! Urgent issue with Glide Ask for Help	26	1634	June 8, 2022
Thanks for the information on your case Ask for Help	3	263	June 9, 2022
Your sheet needs a Row ID column first (yet Row ID exists) Ask for Help	5	703	April 20, 2023
Imported Row ID not recognized as Row ID Ask for Help	13	945	February 20, 2023
ROW ID unlock Ask for Help	1	99	February 21, 2024

Hi there, i already have a uniqe ID column on my googlesheet, can i make that column as my 🔒 Row ID in glide

Related topics