I’m trying to create a view in Airtable that shows just the top row of my table. The tricky part is I want it to update when the table changes due to new entries or sorting. Here’s what I mean:
I’ve looked around but can’t find a way to do this. I tried using some formulas like SELECTFIRST() and LIMITTOP(), but they don’t seem to exist in Airtable. Is there any way to achieve this? Maybe I’m missing something obvious?
I’ve faced a similar challenge before, and here’s what worked for me. Create a new view and use a formula field to assign a unique number to each record, like ROW_NUMBER(). Then, filter this view to show only where that number equals 1. This approach dynamically updates with table changes and respects sorting.
For extra functionality, you could add a ‘pin’ checkbox field. Modify your filter to show records where either the row number is 1 OR the pin is checked. This gives you manual control to override the automatic top row when needed.
Remember, Airtable’s capabilities are always expanding, so it’s worth checking their latest features or community-created scripts for more advanced solutions.
hey sophiac, i think i got a workaround for ya. try making a new view, then set the filter to ‘{Primary Column} is not empty’ and limit to 1 record. that should give u just the top row and update when stuff changes. lemme know if it works!
While the previous suggestion is a good workaround, there’s another method you might find useful. Consider creating a separate single-record table linked to your main table. Use an automation to update this linked table whenever your main table changes. This way, you’ll always have a ‘live’ view of the top row, regardless of sorting or new entries. It’s a bit more complex to set up initially, but it offers more flexibility and can be used across multiple views if needed. Just ensure your automation trigger captures all relevant changes to keep it current.