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	8	1630	February 14, 2021
Grouping items Ask for Help	13	2418	December 5, 2019
How can I group this data by department? Any idea? Ask for Help	4	207	November 22, 2022
Group by relation or lookup column Ask for Help	3	601	May 9, 2021
Pre-defined filters in a dropdown on the home screen Ask for Help	5	272	December 13, 2022

Grouping folders

Related topics