Unique list issue - Help

I have a list of client orders. Fields are Job Number, then PO number, item, description and amount
I want to display a page in Glide Pages that shows all active Job numbers. I want to use the custom component (I think) and have the top level show only the unique job numbers, then inside the next level of the component show all the Pos. I’m puzzled on how to do this to get the list of unique job numbers.

This is the general concept. Let us know if you have questions.

1 Like