Make Directory Show Name Once Vs. Multiple Times for Different Lcoations

I have a table of locations of shops. Many of the shops are of the same name but different locations. I’d like to be able collapse/expand the list for each Shop name rather than showing every location of each shop. For example, I’d like it to just show “McDonalds” once, then expand when I touch it to show all the locations.

Probably you can build a new sheet with all unique brands, then in the details view use a relation to show all locations of the brand. Would that work?

For a “touch”, it can be linked with increment action but it’s not scalable.

Thanks @ThinhDinh it worked. I’m trying to get used to relationships but I’m making progress.

1 Like