Search for values bigger than a value

[#1]

Hi All,

I would like to ask if there is an easy way to search for values bigger/smaller than a given by the user value in the search box or in a dropdown select.

In the perfect case I would like the user to type: '<1000' and all values smaller than 1000 to be selected in this column/list box etc.

Thanks!

[martin59 · Accepted solution]

Hi Sergey,

You can enter "<1000" in your list box to filter your datas <1000

Take care of remove the stars if you click on the Magnifying glass.

Martin

[#3]

Hi Martin,

I knew that I miss something, but I found that the data was not formatted as number/date but as text. After specifying the correct settings in Number tab, this feature works (but obviously only for numeric values).

Many thanks for the help!

Sergey

[martin59]

It works also with dates, on condition that the input date has the same format than the field.

Martin