Subcategories demo missing one explanation

Continuing the discussion from Help Using Categories and Subcategories:

There’s one thing I don’t understand about the demo linked above. When using the GSheet shared by @JackVaughan as the basis for a new Glide App, Sheet 2 > Parent 1 column is automatically made into a Relation Column. How/why?

Also, I can’t edit the Relation for that column, so I can’t even see how it’s relating to something else.

This is what it looks like before I’ve done anything to it. Can someone please explain?Screen Shot 2021-01-25 at 8.41.24 PM

1 Like

That’s not a relation, it’s an array column.
If you look at the source sheet, there are two columns named ‘Parent 1’ and ‘Parent 2’ respectively.
Glide automagically converts those into an array column named ‘Parent’


I couldn’t help but notice that “automagically” is a very fitting word :star_struck:


It’s one of my favourite words, I use it a lot :joy:


Ha! I didn’t even notice “automagically”. Guess I was too busy smacking myself in the forehead, V8 style.