I have a date field in Airtable called ‘Last modified’ that records when a record has been updated. In Softr I have a table view that shows only those records that have a ‘Last modified’ value that is within 30 days (using the nice relative date range option).
But I would like my users to be able to specify the number of days and see a corresponding change in the table - so be able to enter 20 days for example.
Can anyone think of a way of doing this?
A single select field with numbers 1-30?
Then a Softr dynamic block displaying records conditionally on this field/number.
You may have to use a formula field to calculate number < last seen (or similar) to set a flag to be the conditional field for show/hide record.
I’m sorry, but I don’t quite understand.
I am using a conditional filter in the source section of the list block as below.
I can’t see anywhere to pass that a value other than a fixed value (in this case the number 90).
What am I missing?
You are right that you cannot pass another value in those filters.
My suggestion is to use a different approach, where your database is using the value (user choice 1-30) to filter by to make a calculation and return a yes/no result (flag). You then use Softr’s conditional filter to reference that flag and show filtered rows that way.