Grouping folders

[agungmrf]

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?

[agungmrf]

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

[Darren_Murphy]

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?

[agungmrf]

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

[Darren_Murphy]

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:

[Jeff_Hager]

Unique List

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…