# How do i have more than ONE category

**URL:** <https://community.glideapps.com/t/how-do-i-have-more-than-one-category/83872>\
**Category:** Ask for Help\
**Created:** [August 17, 2025, 8:47am UTC](https://community.glideapps.com/t/how-do-i-have-more-than-one-category/83872 "2025-08-17T08:47:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hbrezy](https://avatars.discourse-cdn.com/v4/letter/h/ea666f/32.png) [@Hbrezy](https://community.glideapps.com/u/Hbrezy)\
**Post date:** [August 17, 2025, 8:47am UTC](https://community.glideapps.com/t/how-do-i-have-more-than-one-category/83872/1 "2025-08-17T08:47:16Z")

</div>

Hi everyone, I’m building a directory app where each listing currently belongs to a single category. However, I’ve run into situations where a single listing needs to be associated with multiple categories. For example:

- Listing 1 → January

- Listing 2 → February

- Listing 3 → January **and** February

What would be the best way to structure this in the database? Should I create a relationship (like a many-to-many relationship) between listings and categories, or is there another approach I should use to allow one listing to reference multiple categories?

Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 17, 2025, 9:11am UTC](https://community.glideapps.com/t/how-do-i-have-more-than-one-category/83872/2 "2025-08-17T09:11:56Z")

</div>

In your Listings table you can have a column that contains a comma separated list of Categories. Use a Split Text column to create an array from that, and use the Split Text column in a relation.

You just need to be careful that your category names don’t contain commas. If they do, the above will break down. A workaround to that would be to use CategoryIDs (RowIDs) instead of Category names.

Another way is to create an array directly by using a Multiple Texts column.

---

<div class="post-metadata">

**Author:** ![Hbrezy](https://avatars.discourse-cdn.com/v4/letter/h/ea666f/32.png) [@Hbrezy](https://community.glideapps.com/u/Hbrezy)\
**Post date:** [August 17, 2025, 9:45am UTC](https://community.glideapps.com/t/how-do-i-have-more-than-one-category/83872/3 "2025-08-17T09:45:50Z")

</div>

Thanks for the reply. Will this work even if i have a large database already? or is the solution best if im starting from scratch? Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 17, 2025, 9:46am UTC](https://community.glideapps.com/t/how-do-i-have-more-than-one-category/83872/4 "2025-08-17T09:46:43Z")

</div>

It doesn’t really matter either way. How large are we talking? (total number of rows)

---

<div class="post-metadata">

**Author:** ![Hbrezy](https://avatars.discourse-cdn.com/v4/letter/h/ea666f/32.png) [@Hbrezy](https://community.glideapps.com/u/Hbrezy)\
**Post date:** [August 17, 2025, 9:52am UTC](https://community.glideapps.com/t/how-do-i-have-more-than-one-category/83872/5 "2025-08-17T09:52:07Z")

</div>

> [@Darren\_Murphy](#):
>
> Another way is to create an array directly by using a Multiple Texts column.

Slip text Array worked like a charm! just connected it to my category column and seperated the categories with a comma and voilà! Thanks so much.