It would be great to have a more complex way to filter records in blocks, where you can add groups and have and and or rules and not just one option.
1 Like
Agree - we’ve run into an issue today as we are unable to use a combination of the ‘AND’ and ‘OR’ options. We need to be able to filter based on Dates:
‘Start Date’ is on or before ‘Date’
AND ‘End Date’ is on or after ‘Date’ OR is empty
There is currently no work around for this so we are unable to use Softr for this application
Could you not do a work around in your database and set a flag, conditional on the logic you require, at least for one of the conditions/parameters?
Yes but for the future it would be nicer to handle this directly in Softr
That wouldn’t work for my scenario as it needs to be dynamic based on the date the user selects so not something I can flag in the database
1 Like