I can't edit the type for a columns

Ask for Help
1

Hello,
I’m building my app in Glide, but I have trouble configuring columns as “Relation” types in the Data Editor. I have tables such as Events, Users, Participations, and Organizers. For example, I want to link the “OrganisateurID” column in the Events table to the “ID” column in the Organizers table via a relation, but I can’t edit existing columns to change their type to “Relation.”

When I try, Glide only allows me to add relation columns as new columns, not to change the type of an existing column. My use-case needs certain columns to serve as foreign keys, and then be used as relations. Is this normal, or am I missing a step?
How can I correctly link tables using relation columns if I cannot convert an existing key column into a relation directly?

2

Basic columns can’t be changed to computed columns once they have been created; I don’t think that’s what you’re asking though. REL columns are computed so once you have it setup correctly between your two other columns, it will generate the relation data there.

1 Like
3

Create a separate relation column by referencing two key columns.