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’écran 2021-02-05 à 13.37.54]

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?

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] [3] [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.

[image] Jeff_Hager: 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. 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’écran 2021-02-07 à 09.56.45] then I have this column in single value [Capture d’écran 2021-02-07 à 09.59.13] And I have this column to filter the list according to the user’s choice [Capture d’écran 2021-02-07 à 10.00.53] this is my component inline list [Capture d’écran 2021-02-07 à 10.03.23] And the screen [Capture d’écran 2021-02-07 à 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

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

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

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.

Thanks a lot Darren in the meantime I have succeeded

Filter over a range of numbers

Ask for Help

Darren_Murphy February 7, 2021, 2:46am 5

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

Topic		Replies	Views
New to Glide and can't figure out how to custom filter Ask for Help	1	193	October 20, 2023
Table relations & choice as filter Ask for Help	12	1689	July 7, 2022
Filter choice component options Ask for Help	2	396	December 8, 2021
Is there a way for end Users to filter by data in a list? Feature Requests	4	367	July 14, 2020
Dynamic Form Filter Ask for Help	26	1987	October 19, 2022

Filter over a range of numbers

Related topics