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] [Untitled]

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

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?

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

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]

[image] Unique List Ask for Help 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 fe…

Grouping folders

Ask for Help

Jeff_Hager November 28, 2022, 1:06pm 6

Topic		Replies	Views
Query group by....inside Glide? Ask for Help	9	1626	January 17, 2024
Grouping items Ask for Help	13	2412	December 5, 2019
How can I group this data by department? Any idea? Ask for Help	4	204	November 22, 2022
Group by relation or lookup column Ask for Help	4	597	January 17, 2024
Pre-defined filters in a dropdown on the home screen Ask for Help	5	266	December 13, 2022

Grouping folders

Related topics