How to use formula generated content in Airtable as a filter in Softr

Hello, I’m currently building a internal management tool for a restaurant with Airtable and Softr. I would like to propose a page where employees can calculate their shifts monthly, filtering by month (how many shifts in december 2023 ?). Problem is : softr don’t allow filter based on raw date data. So i had to convert raw date data into a text in Airtable (12/16/2023 → december) thanks to a formula, but here again, Softr doesn’t allow to use formula generated content in Airtable as a filter research. My quesiton is: how can i do to have this monthly research feature in Softr ? I hope this is clear enough, looking forward to read your solution :slight_smile:

Yes, you can use a formula field to filter content on your list blocks.

The output of your formula in airtable should look like ‘Value1, value2, value3’

Let me know if this helps your use case.

Hello acjnas,

Thanks for your quick reply !

And yes this helped me thank you, now able to finish my project :slight_smile:

Have a nice week,

Pierre-Louis