Describe the bug: I am building an app on top of a MS Excel sheet I want to add a new column in one of the tables If I try to add a column from glide data editor, the column is always “user-specific” The uncheck box is disabled, so I am not able to deselect the box for any new column Expected beh…

I’m not sure if that’s a “feature” or a bug. I believe @David_Gabler or @Darren_Murphy may have more experience on this, so the question is can Glide actually create a column in the Excel file?

Not me, sorry. I’m allergic to Excel :stuck_out_tongue:

I will be highly disappointed if it’s a feature. Not a fan of Excel either, but it’s a client requirement to link it to Excel and I won’t be able to create custom glide columns now…

I’m not sure either, but I wonder if this may be a limitation of the Excel API that Glide can’t do anything about. I would think you could still add non user specific columns directly in the excel sheet if needed.

That’s what I have been doing. But it doesn’t let me create custom math, relation, etc. columns that are not user-specific. :expressionless:

[image] optimus_prime: it doesn’t let me create custom math, relation, etc. It does require you to create new physical columns on the Excel side, but for computed columns (like relations, etc.), that checkbox is not there. [image] I was really excited when the Excel interface was announced …

So you can’t change the column type to a Math column when creating a new column? There’s no such thing as user specific or not user specific when it comes to computed columns. They only become user specific if they are using another column that’s user specific. Just to be clear… are you trying to…

No no that is expected behaviour, always been like that. Once you create a column with USC unchecked you cannot go back and switch it to user specific/USC… OR vice versa. (i always assumed there was too much coding connected to that column to just flippantly switch USC on and off) [Are you sure yo…

no this is not the case. all new columns have that checkbox disabled. looks like a bug, unless someone can confirm it’s due to limiations of Excel API

Unable to uncheck user-specific column

Report a Bug

optimus_prime January 17, 2023, 4:49pm 10

This situation is not unique. I raised another ticket reporting this issue: Rows getting deleted automaitcally on Excel - #2 by Darren_Murphy

Topic		Replies	Views
How to unblock the user-specific check box? Ask for Help	7	423	February 13, 2023
User Specific Columns on Existing Columns Ask for Help	6	598	July 2, 2021
User Specific Columns + User Profiles Demo Community Resources tutorial	89	5320	May 31, 2020
🆕 Change type of basic column General	26	1246	September 27, 2020
Data in Glide tables disappearing Report a Bug	33	1506	April 29, 2024

Unable to uncheck user-specific column

Related topics