Show First Row in a Database

I’ve searched the forum, but none of the topics I found really gave me a solution for what I’m looking to do. And, honestly I feel really dense that I’m asking this question & can’t get it to work.

I have a pretty simple database that has the following fields: name, date, and 3 image fields

On a page, I have a view where I only show the first row in the table as a card (sorted by date). But, for the life of me, I cannot figure out the right filter and nothing I have tried will work.

Dear @LaRosa_Johnson welcome to the Coda Makers community

Please have a look at this post Last date using Max() - Not working! - #8 by Paul_Danyliuk

Instead of max() use min() or reverse the sort order

Thanks for the reply. It pointed me in the right direction. Here’s what I ended up using to get it working.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.