Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 30, 2021 09:45 AM
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?
Jan 30, 2021 10:44 AM
Follow the instructions given in this very similar thread.
Jan 30, 2021 03:11 PM
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?
Jan 31, 2021 10:10 AM
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.
Feb 05, 2021 02:52 PM
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