Same product, Different Categories?

I’m trying to figure out a way that I can have each product be listed for multiple categories. For example, I have product A. This product could fit into category A & category C. I can use the relation setting so when I select category A, it shows a list of all it’s products including product A. But I also want product A to show in Catagory C. So basically I want product A to have multiple relations?

Would I be able to use a comma or semicolon in the relation columns of the products so they appear in multiple categories? What is the best way to go about this?

Hi Brian,

You can use an array column to achieve that. Name the columns Category 1, Category 2, Category 3 and fill the values in (Category A in column Category 1, for example.

Where can I learn to create an array column? Is this different from multiple relation columns?

It’s different. You can have a read about it here.

https://docs.glideapps.com/all/reference/data-editor/computed-columns/array-column#:~:text=Array%20columns%20combine%20the%20data,next%20number%20in%20each%20column.

Thank You for the help!