Hello! I have a details tab linked to two different sheets. Within one sheet (for example), I have a list of names and meeting data attached to them. Some of these names repeat, and I am trying to group those names so that when I click through to them on the app, all the meetings are displayed under one name. And then the same for my other sheet. Is this possible within the Details layout? Thank you!
I would create a new sheet with just unique names. That sheet would be your list. Then I would set up a reference to your existing sheet linking the name from the new sheet to the name of the existing sheet. That will give you a list of unique names and clicking on each one will expand to a list of meetings for each name.
1 Like
i am a new user. can you please show me how to do this part ‘Then I would set up a reference to your existing sheet linking the name from the new sheet to the name of the existing sheet’.
Take a look at this link. I would pay special attention to the Match Multiple Relations link. That should give you a good overview of how relations work.
This helps. But I am still not able to get the results I want. Basically my spreadsheet consists of Batch names A19, B19 through Z19. and host sites - OVGG, GAA17. Each batch has multiple activities associated with it - build, turn, sift.
I only want A19 to appear once on the list screen. And when I go into details I’d like it to show the dates when it was built, turned and sifted.
I know I need to structure my data a bit differently. Any pointers you can provide are greatly appreciated!
Here is an excerpt of the tab.
|Date|Hub|Batch|Activity|
|12/29/18|OVGG|A19|build|
|1/4/2019|GA-A17|A19|build|
|1/5/2019|OVGG|A19|build|
|1/6/2019|MesaCollege|A19|build|
|1/11/2019|GA-A17|B19|build|
|1/12/2019|OVGG|B19|build|
|1/13/2019|MesaCollege|A19|build|
|1/18/2019|GA-A17|B19|build|
|1/19/2019|OVGG|B19|build|
|1/20/19|MesaCollege|A19|build|
|1/25/2019|GA-A17|B19|build|
|1/26/2019|OVGG|C19|build|
|1/27/19|MesaCollege|B19|build|
Shouldn’t be a problem. I would create a new sheet that contains the batch names. You can either type them in manually or use a formula such as =UNIQUE(ExistingSheetName!C2:C). This new sheet will become your primary tab in the app. You can then create a references to link the batch from the new sheet to the batch in the existing sheet. Once that is done, I believe when you select a batch in the list, it will open up a screen for that batch. There you would add an inline list that uses the new reference field you created. This should show a list of all activities that match that batch.