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.