# Grouping folders

**URL:** <https://community.glideapps.com/t/grouping-folders/55062>\
**Category:** Ask for Help\
**Created:** [November 28, 2022, 7:35am UTC](https://community.glideapps.com/t/grouping-folders/55062 "2022-11-28T07:35:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![agungmrf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agungmrf/32/50700_2.png) [@agungmrf](https://community.glideapps.com/u/agungmrf)\
**Post date:** [November 28, 2022, 7:35am UTC](https://community.glideapps.com/t/grouping-folders/55062/1 "2022-11-28T07:35:29Z")

</div>

Good afternoon everyone, permission to ask how to group from image1 to image2? but I don’t want to need to add a new sheet manually and then do a relation from that sheet? anyone know?

 ![image 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20397e57611c99378e4186da2a864c488cbe664a.png)

![Untitled](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f17d3b801cc02b618f57578d84ceb13260e558d1.png)

---

<div class="post-metadata">

**Author:** ![agungmrf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agungmrf/32/50700_2.png) [@agungmrf](https://community.glideapps.com/u/agungmrf)\
**Post date:** [November 28, 2022, 7:42am UTC](https://community.glideapps.com/t/grouping-folders/55062/2 "2022-11-28T07:42:26Z")

</div>

The following is the data process when the user wants to add a new item

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8eda17473e75df3ed4093e7458b8d7dc6afa9cd3.png)

---

<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:** [November 28, 2022, 7:56am UTC](https://community.glideapps.com/t/grouping-folders/55062/3 "2022-11-28T07:56:26Z")

</div>

I’m sorry, I don’t understand what you are wanting to do.  
What are Data and PAP? Are these categories of files, or something like that?  
Can you show a screen shot of the Glide Table that new records are added to?

---

<div class="post-metadata">

**Author:** ![agungmrf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agungmrf/32/50700_2.png) [@agungmrf](https://community.glideapps.com/u/agungmrf)\
**Post date:** [November 28, 2022, 8:04am UTC](https://community.glideapps.com/t/grouping-folders/55062/4 "2022-11-28T08:04:09Z")

</div>

Oh yes, sorry, so the data and pap are obtained from the user’s user sheet

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aa1b4391210ccd5071502c32a61bf9e60522daa7.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/49728cb0037358082af0320d179a49e347c79452.jpeg)

---

<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:** [November 28, 2022, 8:07am UTC](https://community.glideapps.com/t/grouping-folders/55062/5 "2022-11-28T08:07:24Z")

</div>

So you want to display a collection of the data in your Division Table, and group it by Department, yes?

If so, you can use the Group By option that’s shown in your first screen shot:

 ![Screen Shot 2022-11-28 at 4.05.17 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7f4175a3522d7338d0abec464477a1b0b38160ee.jpeg)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 28, 2022, 1:06pm UTC](https://community.glideapps.com/t/grouping-folders/55062/6 "2022-11-28T13:06:55Z")

</div>

> [@Unique List](https://community.glideapps.com/t/unique-list/24276/2):
>
> Here is a technique that I learned from @Jeff_Hager. You will need a RowID column in your sheet. Create a self-relation linking the company name to itself. This should be a single relation (call this rel-self) Create a Lookup column to fetch the RowID from that relation (call this lk-unique-id) Finally, create an if-then-else column: If RowId is lk-unique-id, then true. Else blank. (call this ite-is-unique) You can now use this last column to filter your Inline List: “where ite-is-unique is t…
