Complex Logic - Relationships

Ask for Help
1

Tried getting excel data to flow in glide, and perhaps I need to adjust some of my worksheets, but I’ve listed the case below, and need help establishing which relationships/queries or other columns are essential.

High-level overview
5 Tables (worksheets):
[1] Brand (Store name)
[2] Locations
[3] Categories
[4] Subcategories
[5] Items

So far:

  • One [1] brand has many [2] locations and [2] locations relate to [1] brand
  • One [2] location has many [3] categories and [3] categories do not relate to [2] locations.
  • One [3] category has many [4] subcategories and [4] subcategories relate to [3] categories
  • One [4] subcategory has many [5] items and [5] items relate to [4] subcategories

Assumptions
All [2] locations have the same [3] categories.
All [2] Locations of the same [1] brand have the same [5] items.

Problem
Eventually when I click through all the screens Brand > Locations > Categories > Subcategories > Items. I have Items showing from all brands with the correct category & subcategory. Whereas I would hope to have all the items pertaining to the selected brand & location & category & subcategory. the relationships or structure of my data is not allowing this what solutions exist so I only see the items for the correct brand/location i am in. thank you!!!

2

So you will only show items on the Items screen, not anywhere else, and you want to have the context of all brand, location, category & subcategory you have navigated through to that point?

I think that will be doable if you use set column actions through the way there, or extract the relevant IDs from the screen URL.

3

Thank you for the suggestion - I might revisit this thread if still stuck, Best!

1 Like
4

This is what I would do for sure. Get the screen URL using a template column. This deeplink will contain all the RowIDs of your breadcrumb path. Then, you can add filters/relations based on these values to only show the items pertaining to the screen URL

1 Like
5

Thread resolved! So thrilled it is working

1 Like
6

Great to hear!

7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.