I have two fields. Let’s say: MIN and MAX and a have a Entry in database with Field type - Number.
I need that:
If users types in only MIN number (max value is empty) - Search would display entries where Number is THIS Number or Greater.
If users type in only MAX number (min value is empty) - Search would display entries where Number is THIS Number or Less.
There are several problem with this:
- Because currently in Bubble there is no search filter option for number “greater or equal” and “less or equal” I can only select > or < operators, but in that case Bubble will find all the records where number is less or greater without including entered number. Example: Min is 1 - Search filter is > 1 - Bubble will find records where number is 2 or Greater
- I know that I can use a workaround and add +1 for < operator and -1 for > operator (to include entered value), but guess what - It doesn’t work if value is empty.
I know that I can make a different search filter with - ONLY WHEN scenarios - but if I have 5 numeric values that I need to search that means I have to create 10 Search Filter for each scenario.
I really hope that this topic will be focused by Bubble developers because this is a quite fundamental things that need to be available in Bubble.