I have a HUGE Coda Doc with lots of master and child tables and dashboards that present views of other tables. It’s essentially a Customer Success Platform built in Coda. Here’s my question.
On my dashboard I want to display only the three most recent rows (in my master meeting notes table) that match the name of the customer I’m currently looking at.
E.g. I am looking at the dashboard for my activity with Acme Corp. I want to have a view of the Master Meeting Notes table that only shows the 3 most recent meetings with Acme Corp. I’ve been filtering it by date and that’s fine, I guess but just would rather see the three most recent meetings regardless of time. I think it would need to involve RowID() but I’m not terribly sure how to just pull the three most recent rows using RowID(). Wasn’t sure if there was another formula I should be thinking of.