I have an SQL Server table with a primary key and identity column called ‘ID’. This column has to remain the primary and identity as its used by my main application. When I add this table to Glide it doesnt detect this column. Therefore, I creating another column called ‘GlideID’ which Glide can …

I apologize if this is a basic question, but I haven’t used SQL Server as a data source in Glide before. When you say “Glide doesn’t detect this column,” do you mean that the column isn’t being imported at all, or that it’s being imported but not recognized as the ID column? If it’s the latter, Gli…

The former, it’s not being imported at all. In my example, ID is my identity column. GLIDEID is the unique column for the Glide app. [Glide1] [Glide2] You can create new rows from within Glide app (the identity column and the GLIDEID update correctly). However, the problem is the identity co…

Would it help if you created your own ID column? When rows are added from Glide use the Unique Identifier and when added from outside glide a different unique Id generator. My guess is if you had a column with unique ids you could figure the rest out.

The ID column is used as the unique identifier outside the app and cannot be changed to another column. The GLIDEID is used as the unique identifier just in Glide. Ideally, you want the GLIDEID from Glide to sync its value to the SQL table if its null. Not sure if this is possible?

I am wondering if the issue related to GLIDEID column being NULL when synched back is related to datatype of the column in SQL server. What is the column’s datatype on the server and how are you populating it on the server? If it is a UNIQUEIDENTIFIER column, can you try to use a character column in…

The datatype is varchar(4000). The GLIDEID is generated by Glide and syncs fine with the server when a new row is created in Glide, so I do not think its a datatype issue. The problem is when a new row is created outside Glide. Glide needs to detect the new row, create a new GLIDEID value and syn…

My application is an inventory management system and the ID column is used as part of the asset numbering, so the numerical ID indentity auto increment is critical. I have over 20 tables (with 1000s of rows) and all use a numerical autoincremented indentity, so moving to a GUID wouldnt work.

@raajkumars is not saying you need to touch the ID column. He’s just saying to add something to your external process to populate the GlideID column from Glide when adding rows within Glide, and populate it with your external process when a row is added outside of Glide. In the same way you can ad…

I appreciate that, if the application had a few tables and a few new row events this would be possible. But the external application is well established (code wise), so trying to find every new row event for every table to populate another column with a GUID wouldn’t be practical (cost and time).

SQL Server Identity Column Detection

Ask for Help

raajkumars May 10, 2024, 4:22pm 8

Ah I see. In that case, perhaps you can populate the glide id column using a guid on the server when new rows are added there.

Topic		Replies	Views
SQL Server Identity Column Ask for Help	5	203	May 17, 2024
MS SQL identity columns Ask for Help	2	149	May 3, 2024
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	11	540	August 14, 2022
ROW IDs ! Urgent issue with Glide Ask for Help	26	1634	June 8, 2022
Row ID's \| Not Automatically Adding Ask for Help	9	649	November 24, 2020

SQL Server Identity Column Detection

Related topics