- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2025 08:02 AM
I have a 4 table layered structure in my base. VP<->Objective<->KR<->Project. Each layer has a link to the layer above/below it. I am creating an interface to show all of the work under each VP. For Objectives solely under 1 VP, this is working great. My challenge is that we have some Objectives that are shared between multiple VPs. When I show those, I want the table to look like this:
Shared Objective
Shared KR
Projects (filtered to show only the selected VPs projects)
I have fields in the Projects table that I can use to filter, but have no way (that I can see) to apply a filter in this way.
I tried creating a link from Project<->VP. From that, I can build a table of Projects grouped by KR, but I can't show any of the KR information in the table. Is there a way to do what I am trying?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2025 09:00 AM
Hey @chriswoodrow,
What interface layout are you using? List?
Would you mind sharing a couple of screenshots of your structure, and of your problem? This will make it way easier for me to help out 😄
Thanks!
Mike, Consultant @ Automatic Nation
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2025 11:08 AM
@Mike_AutomaticN - Thank you for your help!
This is an example of the 3 tiers, but showing Projects for all of the teams.
Here is the best I can achieve just showing Projects and grouping by KR. I show only the Projects for the VP's team, but can't get any details showing for the KR level.
And, yes, I am using a List interface layout.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2025 06:12 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 14, 2025 06:12 AM
That looks nice, but not quite my issue. Looking at my example, you can see that all VPs (Tom, Sue, and Mary) have a link to "Common Obj A"
In the Projects table, each VP has a Project under "Common Obj A"
My question is, how do I show a List view on the Interface for any given VP that shows "Common Obj A", but only has their Project under it. For example, for Sue:
Objective | Key Result | Project |
Obj 2 | KR 2 | Proj 2 |
Common Obj A | Common KR A | Proj 2A |
