Inline within Inline

Ask for Help
1

Hello Gliders,
I’m trying to do the following and am getting stuck at which column(s) needs to be the relation anchor in my spreadsheet. Any help is greatly appreciated.

So I have 4 locations (A,B,C,D), each location has 4 product lines (i,2,3,4) and there are 5 tasks (a,b,c,d,e) that can be performed on every product at each location. My spreadsheet has the following columns:
Location | Date | Product | Task

I want to accomplish the following via the first screen “Product Screen”:

  1. Start with card layout of locations. Click on the location and it shows a list relation component of products which were worked on at that location.
  2. Click on the list component and it shows all products for that location. There could be multiple entries for the same product at each location with different dates. So I only want to see a unique list of products.
  3. Click on the product and it shows all dates where some task was performed on that product. So shows date and task details.

I also want to offer this same information date wise with the following workflow:

  1. Start with card layout of locations. Click on the location and it shows a list relation component of dates when work was performed at that location.
  2. Click on the list component and it shows all dates when work was performed at that location. There could be multiple entries for the various product at each location with same date. So I only want to see a unique list of dates.
  3. Click on the date and it shows all products where some task was performed on that date. So shows product and task details.

The location details are in the first sheet. The Task details are in a second sheet. I am creating a new relation column in the location sheet matching (multiple) the locations from the first and second sheet. If date is the first column in the Task sheet it picks up the same date as many times as it appears in the spreadsheet. I only want unique records for that location. If product is the first column in the second sheet then it picks up the same product as many times as it was worked on at that location. I only want unique products.

Also will I have to create a duplicate of the task sheet to accomplish the two different views - product and date?

Thank you very much for reading this and for offering suggestions.

2

First of all unique or not, a relation is always going to show the first column of the related rows. It’s just showing that it found a match, but in actuality it’s relating to the entire row. There seems to be confusion sometimes with people think that something isn’t showing correctly.

It’s going to show duplicates because you have duplicate rows in the related sheet. What you need to do is create 2 new sheets. Each one using the unique formula in google sheets to get a unique list of product names or a unique list of dates along with location. From the location sheet you will need to create a relation to these new unique sheets. So when you click on a location and then click on the list relation, you will see the list from the unique sheet. Clicking on an item in the unique list will open up it’s details. From here you will need to create a relation to the actual products sheet and display it as a list on the unique sheet details view.

If you need a little inspiration, look at Multi-Level Select in https://concepts.glideapp.io/

3

Thankyou Jeff for walking me through the steps. It took me some time to figure out the circular relations between sheets but I followed your description step by step and it is working beautifully! Thank you!

1 Like