Subcategories demo missing one explanation

[belzoni]

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?

[Darren_Murphy]

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’

[Eric_Penn]

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

[Darren_Murphy]

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

[belzoni]

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

Thanks!