# Trying to make distance preferences (\> 5,10,25 miles)

**URL:** <https://community.glideapps.com/t/trying-to-make-distance-preferences-5-10-25-miles/62687>\
**Category:** Ask for Help\
**Created:** [June 12, 2023, 2:40pm UTC](https://community.glideapps.com/t/trying-to-make-distance-preferences-5-10-25-miles/62687 "2023-06-12T14:40:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [June 12, 2023, 2:40pm UTC](https://community.glideapps.com/t/trying-to-make-distance-preferences-5-10-25-miles/62687/1 "2023-06-12T14:40:07Z")

</div>

I want users to be able to select a proximity for the businesses they want to see:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/2/b26d0c5850972bae741a33bb08aac27b039a9d55.jpeg)

I’m about half way there, I just can’t seem to connect the actual selection, to all the businesses LESS THAN that distance.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/967c47693561c2627c137d690c3e1be31d54679a.png)

I have the distance  
I have the salons within those distances checked  
I have the selection  
And now I’m stuck! (I can’t figure out how to connect the selection back to the conditions that fit it.)

---

<div class="post-metadata">

**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:** [June 12, 2023, 3:02pm UTC](https://community.glideapps.com/t/trying-to-make-distance-preferences-5-10-25-miles/62687/2 "2023-06-12T15:02:00Z")

</div>

- Add a Single Value column that that applies the selected distance to all rows
- Now create an if-then-else column:  
– If Single Value distance column is empty, then true  
– If Distance to Salon is less than Single Value distance, then true
- Combine that with your other filters (if-then-else is checked)

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [June 12, 2023, 9:13pm UTC](https://community.glideapps.com/t/trying-to-make-distance-preferences-5-10-25-miles/62687/3 "2023-06-12T21:13:21Z")

</div>

ok i added single value column and then started the if-then-else, but it won’t let me compare the current distance to user (meaning salon distance to user) to a single value?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/0410c72b49a922e2f92bfeff69101bc97e9a2c0e.png)

Do i need to make the single value into a roll up so it knows it’s a number?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [June 12, 2023, 9:18pm UTC](https://community.glideapps.com/t/trying-to-make-distance-preferences-5-10-25-miles/62687/4 "2023-06-12T21:18:24Z")

</div>

nope, that doesn’t work

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 12, 2023, 11:42pm UTC](https://community.glideapps.com/t/trying-to-make-distance-preferences-5-10-25-miles/62687/5 "2023-06-12T23:42:13Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9be0daa47f690bfa2c943130bfbb77604f56eeb.png)

You were using a text column type for the original “Distance toggle selection”. Has to be converted to a number.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d4c1d35fb27c6fb9f758226867463b92a04591ed.png)

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [June 13, 2023, 2:02am UTC](https://community.glideapps.com/t/trying-to-make-distance-preferences-5-10-25-miles/62687/6 "2023-06-13T02:02:09Z")

</div>

🫠 Oh right haha got it. You’re the best, thanks! And thank you @Darren_Murphy