Filter over a range of numbers

#1

Hi everyone, I’m Flo
I’m new to glide and I’d like some advice on filter a range of numbers.
I have a list of electric scooter with different items like price, autonomy, the weight … and stuff like that.
For example for the price I would like my filter to look like this
less than 500
from 500 to 1000
from 1000 to 1500
from 1500 to 2000
from 2000 to 2500
…
in increments of 500 to 4000 and more

For the weight an example
less than 20
from 20 to 25
from 25 to 30
from 30 to 35
more than 40

But I have a first problem, I can’t put these values in my filter. These are the values of my price column which if put in my filter are.
I used the tutorial of @Robert_Petitto
I made a column for price selection, autonomy selection etc…
then a column price single etc… and a column ifPrice …

But the result is not what I want
thank you in advance for your feedback

Capture d’écran 2021-02-05 à 13.37.54
Capture d’écran 2021-02-05 à 13.37.54435×675 26.7 KB

#2

Are you saying that the choices aren’t showing what you want? Where is the data for your choices coming from? Do you have an screenshots of that choice data?

#3

hi jeff
here are the screenshots
the number 1, 2 and 3 are in the same table in glide and the number 4 and a google sheet is linked to the user’s choice!
1|690x36

2
21723×51 8.33 KB

3
31702×48 5.37 KB

4

#4

Maybe I’m not understanding. Your third screenshot shows values that you can use for your choice components, but it doesn’t appear that you are using that sheet in your third screenshot as the source for your choice component.

1 Like
#5

hmm, this seems similar to this question, except with multiple filters.

1 Like
#6

Absolutely In fact I will try to be clearer I mean more specific.
This column displays the values of the user’s choice so his selection
Capture d’écran 2021-02-07 à 09.56.45

then I have this column in single value
Capture d’écran 2021-02-07 à 09.59.13

And I have this column to filter the list according to the user’s choice
Capture d’écran 2021-02-07 à 10.00.53

this is my component inline list
Capture d’écran 2021-02-07 à 10.03.23

And the screen
Capture d’écran 2021-02-07 à 10.05.01

Now what I would like to do is that when the user selects 20 for example show him the items in the list that are between 20 max and 10 min.
If he selects 30 he displays the items from 20 to 30 and so on.
I hope you understand better now

#7

that’s right it looks like it

#8

So perhaps a slight variation of my first response to that question could work for you?

#9

may be
I’m not getting anywhere anyway at the moment

#10

I expect that I can help, but it would be much easier if I can see it in front of me.
If you don’t mind making your app available to copy, I can take a look.

#11

Thanks a lot Darren in the meantime I have succeeded

2 Likes