Lookup one value from multiple linked records

[Jac_Evans]

I have a table TEAMS and another with MATCHES, each match has a SCORE.

I want to show the most recent score for each team but looking at all of their linked matches and then doing a lookup on the match with the latest created at date. Is that possible?

[Kamille_Parks]

Follow the instructions given in this very similar thread.

Show most recent status update per Step Base design

I am looking to show the most recent status update for each step. My table includes: Objectives Steps (Individual steps within the objectives) Team Members Status Reports (form for the team members to submit updates for each steps) A few questions: Should I create some sort of a filter/automation within the Status Report table to show the most recent status per step? Do I need another table (something like “Most Recent Updates”) that pulls from Status reports and somehow only shows the m…

[Jac_Evans]

That works, thank you! Do you know if its possible to style the result colum (the fomula) so it looks like a single select / lets me group like a single select? I could just use automations here i suppose?

[kuovonne]

No, it is not possible to style a formula result to look like a single select. It is possible to group records in the Grid view based on the formula result, but it is not possible to put items in a KanBan view based on formula results. You could use automations to copy the formula result to a single select field, but the added complexity to your base probably isn’t worth the visual changes.

[Daniel_Halenko]

Kamille_Parks:

Follow the instructions given in this very similar thread.

OMG. thankyou SO MUCH. 4 hours of searching to find an answer.
Theres whole feeds on here of ppl trying to find this solution, but i cant find them now.

Thanks for the link to it #mademyday

D