# Filter over a range of numbers **URL:** \ **Category:** Ask for Help\ **Created:** [February 5, 2021, 12:58pm UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281 "2021-02-05T12:58:10Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\ **Post date:** [February 5, 2021, 12:58pm UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/1 "2021-02-05T12:58:10Z")
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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab1c74c83c25e58d368c6d2fce6bd5a0e094f4e8.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 6, 2021, 4:52pm UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/2 "2021-02-06T16:52:59Z")
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? ---
**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\ **Post date:** [February 6, 2021, 7:53pm UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/3 "2021-02-06T19:53:51Z")
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](https://community.glideapps.com/uploads/short-url/rMS8bCPYEKaesGgpDkFmPudDhFQ.png) ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f1d97b442376dd9667f9a5a1ca78355ea0036210.png) ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/22e1772254d01b9c3399a33ed0816fadfeb4622b.png) ![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/413687a527165aac0f78709ee831cc94a9a9b4b6.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 6, 2021, 10:21pm UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/4 "2021-02-06T22:21:59Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2021, 2:46am UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/5 "2021-02-07T02:46:50Z")
hmm, this seems similar to [this](https://community.glideapps.com/t/matchup-one-user-selection-with-multiple-items/22272) question, except with multiple filters. ---
**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\ **Post date:** [February 7, 2021, 9:11am UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/6 "2021-02-07T09:11:14Z")
> [@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’écran 2021-02-07 à 09.56.45](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b7f045f954d9f981b470d09645ca2a9819f0b5e1.png) then I have this column in single value ![Capture d’écran 2021-02-07 à 09.59.13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80f66c1e00b9500016545d2f77f86810845a0626.png) And I have this column to filter the list according to the user’s choice ![Capture d’écran 2021-02-07 à 10.00.53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/73c9e932eb025e1ca71339f66c15dce4d75bb8dd.png) this is my component inline list ![Capture d’écran 2021-02-07 à 10.03.23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/be22c693efb6f9f6f94dfeb18ddfea40158f87b2.png) And the screen ![Capture d’écran 2021-02-07 à 10.05.01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c1e9e2ce205522b149f51f6d589b9c2f58341810.png) 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 ---
**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\ **Post date:** [February 7, 2021, 9:14am UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/7 "2021-02-07T09:14:04Z")
> [@Darren\_Murphy](#): > > hmm, this seems similar to [this](https://community.glideapps.com/t/matchup-one-user-selection-with-multiple-items/22272) question, except with multiple filters. that’s right it looks like it ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2021, 11:18am UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/8 "2021-02-07T11:18:34Z")
So perhaps a slight variation of my first response to that question could work for you? ---
**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\ **Post date:** [February 7, 2021, 12:18pm UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/9 "2021-02-07T12:18:37Z")
may be I’m not getting anywhere anyway at the moment ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2021, 3:36pm UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/10 "2021-02-07T15:36:40Z")
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. ---
**Author:** ![lepetitRider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lepetitrider/32/21071_2.png) [@lepetitRider](https://community.glideapps.com/u/lepetitRider)\ **Post date:** [February 9, 2021, 8:51am UTC](https://community.glideapps.com/t/filter-over-a-range-of-numbers/22281/11 "2021-02-09T08:51:55Z")
Thanks a lot Darren in the meantime I have succeeded