I’m trying to create a page that shows Objectives/Key-Results at a glance. The ideal for me would be That each objective is listed with a number of its fields, then the KRs appear beneath in a data table.
The closest I can get so far is a grouped table. This shows One field of the parent item (objective) then a limited amount of data of each KRs (child). I’m almost ready to settle that this is as close as I can get. Before I do, I wondered if I was missing something.
Issues with this approach
Unable to add parent level fields to the page
Unable to add navigation to click through to each parent
Create a relation column linking Objective to KR. Then in the Objective detail screen, you add a collection sourced from the relation. Another option is to add a collection to the objective detail screen and filter by the screen values of the objective you are viewing.
If you want all of this on one screen, then do the same as above, but use custom collection to display each Objective and it’s related KRs on the same screen as a list.
I’m doing the first of those already. It’s the one screen I can’t work out.
Let’s say I have three objectives, each with three KRs. Should something like the following be possible? I can’t figure out how to nest the lists and because I don’t know how many KRs there will be I can’t have the values as look up fields under the objective.
Objective one name
Ob1 due. Ob1 confidence.
Ob1 details
KR 1.1 Name
KR1.1 elapsed time / KR 1.1 progress
KR 1.1 owner
KR 1.2 Name
KR1.2 elapsed time / KR 1.2 progress
KR 1.2 owner
KR 1.3 Name
KR1.3 elapsed time / KR 1.3 progress
KR 1.3 owner
Objective two name
Ob2 due. Ob2 confidence.
Ob2 details
KR 2.1 Name
KR 2.1 elapsed time / KR 1.1 progress
KR 2.1 owner
Can you give me a blue on how to do this with custom collections? I’ve scoured the forum and the docs, watched a number of videos and tried everything I can think of trying in the UI and I am no closer to getting a nested result like that.
I don’t think I’ve retrained by brain to “think in glide” yet.
Clearer image of what I am trying to achieve (more about the structure than the actual layout)
Blue are rows from the Objectives Table. Red is from the KRs table. Both are have relations to the other. Ive shows buttons really just to indicate that I want a way to link to each.
Is there are way to get this all on one page like this or am I expecting too much?
With a custom collection you can add components inside a container, and it will be repeated for each item.
In your case, create a custom collection linked to your Objective table. Add components inside the custom collection container to show different values for your bojectives. Assuming you have a relation linking Objective to KR, add a collection inside the custom collection container and set it’s source to the relation in the objective table.
I have used Custom Collection to do (for example) the objectives part, looping to create the output I want from that table. It is the sub loop on KRs that I can’t work out.
Are you saying to have the KR data in the objectives table through the linked records? Is that array fields or similar? Basically I can do either the red part or the blue part, but am clearly missing some concept that gets me both on one page.
Not entirely unrelated: If you offer paid coaching or a ‘done with you’ option on Glide please do pitch me on it. I’d like to get proficient enough that I can build my own tools without having to bug people on the forum!
Just add a collection inside of the custom collection and set it’s source to the relation that you said you already have, linking Objective to KR. If you already have a custom collection, then putting a collection inside of it is the only piece left.
You are not alone. I did the same thing for several months when I started working with Glide. I used to watch Bob’s videos and they would just turn my brain to mush. But after a while, the pennies started dropping one by one…
It’s a shame that the documentation isn’t more in depth. I have no idea how some people are working these things out. There is so much that just doesn’t exist in docs.
Mostly though, my issue is that I am dipping in and out. I’m grabbing an hour or two to work on glide a couple of times a week. Sometimes not for a week or too. I think I’m repeating mistakes because I am not using it quite often enough for some of it to sink in.
Despite all of that (and a good amount of shifting my own goalposts), I’ve built something that I think absolutely kicks-ass. That says a lot for Glide.
