# How to setup categorisation **URL:** \ **Category:** Ask for Help\ **Created:** [May 4, 2021, 4:53am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374 "2021-05-04T04:53:02Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 4, 2021, 4:53am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/1 "2021-05-04T04:53:02Z")
Hi, (updated to fix the bullets) I have tables with fields as follows; - Product 1. Category 2. SubCategory 3. Location - Location 1. Name - Category 1. Category 2. SubCategory I want to create a user flow which is as follows; List of locations \> clicking on a location takes to \> List of categories \> clicking on categories takes to \> Products I have been able to create a single level of categorisation, Locations \> Products… Any suggestions on how to take it to 2 level categorisation? Regards, Ruchika ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 4, 2021, 5:00am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/2 "2021-05-04T05:00:46Z")
you need to create columns to relate to next lists… each product need to have separate column for each step… ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 4, 2021, 5:04am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/3 "2021-05-04T05:04:18Z")
I have the fields… just updated my post with the details… messed up the formatting earlier ---
**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:** [May 4, 2021, 6:44am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/4 "2021-05-04T06:44:37Z")
There is a section in the Glide library that covers this exact scenario… (including a video guide and a sample sheet) [https://docs.glideapps.com/all/guides/deep-dives/design/subcategories](https://docs.glideapps.com/all/guides/deep-dives/design/subcategories) ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 4, 2021, 7:12am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/5 "2021-05-04T07:12:41Z")
Hi Darren, Thanks for the share… From what I understand, I’ll have to denormalise all the possible options… I was trying to avoid this as the data comes from elsewhere where these categories are more like tags in the system. ---
**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:** [May 4, 2021, 7:21am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/6 "2021-05-04T07:21:03Z")
I don’t think so. Any chance you can share a sheet with sample data so I can visualise it a bit better? ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 4, 2021, 7:27am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/7 "2021-05-04T07:27:14Z")
![Screenshot 2021-05-04 at 12.56.54 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/196291d78368e90f97b67bf916ae9034cbc0bbeb.png) I am trying to have List of Locations \> List of Cateogries \> List of items (Titles) ---
**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:** [May 4, 2021, 1:55pm UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/8 "2021-05-04T13:55:47Z")
@RuchikaAbbi apologies, I haven’t had time to have a look at this, and unlikely that I will until tomorrow. Maybe somebody else can jump in and help out in the meantime. ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 4, 2021, 4:37pm UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/9 "2021-05-04T16:37:55Z")
No problem 🙂 ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 4, 2021, 6:33pm UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/10 "2021-05-04T18:33:32Z")
@RuchikaAbbi I reproduced what you want, and showed you the solution. Hope it can help you 😌 ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 5, 2021, 4:55am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/11 "2021-05-05T04:55:41Z")
Thank you so much @Lucas_Pires This worked perfectly! Really appreciate you taking your time for this 🙏🏽 Glide community is seriously committed to helping out! ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 5, 2021, 5:50am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/12 "2021-05-05T05:50:12Z")
Glad it could help you! 😌 ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 7, 2021, 10:08am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/13 "2021-05-07T10:08:55Z")
Uh oh… so it works well to one point… For some reason, when I drilldown into the Category it shows me the relevant items at the top… but as I scroll down… it shows all the other items in the category… 😖 Whereas when I look at the lookup and relation fields in the database… everything is fine. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 7, 2021, 2:21pm UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/14 "2021-05-07T14:21:51Z")
> [@RuchikaAbbi](#): > > when I drilldown into the Category it shows me the relevant items at the top… Sorry, but I didn’t understand what you mean here. Can you send a screenshot maybe? ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 8, 2021, 6:13am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/15 "2021-05-08T06:13:37Z")
![Screenshot 2021-05-08 at 11.39.41 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce307bdf7695a00dfc604d29bea0a57de7f096eb.png) So the items above the red line are the correct items, however below the red line are items not related to the State \> Category drilldown. 🤔 ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [May 8, 2021, 6:40am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/16 "2021-05-08T06:40:13Z")
Hi Ruchika, You may use filtering categories option to filter out the ones you dont need. Would you like to jump on a call to solve this? Do let me know. Can DM me. Would be faster than sending messages. I will try my best to help. ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [May 9, 2021, 6:51am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/17 "2021-05-09T06:51:58Z")
Hey Vijay, Thanks! Can’t come on a call… sharing the app in case anyone can help me debug 😅 > **[Debug App](https://debugapp.glideapp.io/)** ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [May 9, 2021, 6:56am UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/18 "2021-05-09T06:56:22Z")
Not able to see the tabs, It asks for name and image, but after that not able to see anything. Check for the visibility condition for the tab. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52041e7863b83229ab94488f9deaa5becdfa990d.png) ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/how-to-setup-categorisation/26374/19 "2024-01-17T16:52:16Z")