Automatically show record matching day of the year

Ask the community
1

I have a Softr site built on a db in Airtable. One of the tables has 365 rows for the days of the year.

How do I get Softr to dynamically display just the one record that matches today (day of the year)?

(The Airtable table has columns for day of year 1-365, month, day in month, and I can add any others needed)

2

Probably the easiest option:

Create a filtered view in Airtable to only show today’s record. Reference this view in your Softr block.

Otherwise, you could set a flag in a date formula in Airtable to show True/False for date is TODAY and use that as a view condition in your Softr block.

1 Like
3

Thank you, that worked!

1 Like