# Distance column officially available

**URL:** https://community.glideapps.com/t/distance-column-officially-available/10318
**Category:** Ask for Help
**Created:** [June 5, 2020, 1:42am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318 "2020-06-05T01:42:24Z")
**Posts on this page:** 20
**Page:** 1

<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 5, 2020, 1:42am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/1 "2020-06-05T01:42:24Z")

</div>

## Official document

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

## Glide's official announcement on Twitter

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

## Some notes

- Compute distance between 2 locations, 1 needs to be stored in your data (can be address or pair of latitude/longitude).
- Glide needs approval to use browser’s location to use this feature.
- Distance calculated in kilometers.
- The same quota applies here as for the map pins, which is 10 for free apps before upgrading.

---

<div class="post-metadata">

### 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: [June 5, 2020, 2:45am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/2 "2020-06-05T02:45:19Z")

</div>

This will be fun to play with. I assume we will just need to do the math to convert from km to other units.

---

<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 5, 2020, 2:47am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/3 "2020-06-05T02:47:03Z")

</div>

Yeah, but with a Pro app, obviously.

---

<div class="post-metadata">

### 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: [June 5, 2020, 2:49am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/4 "2020-06-05T02:49:15Z")

</div>

Why Pro only?

---

<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 5, 2020, 2:52am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/5 "2020-06-05T02:52:25Z")

</div>

I meant to talk about the quota with the free apps, so if you want to test something on a big scale then a Pro app must be used.

---

<div class="post-metadata">

### 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: [June 5, 2020, 2:53am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/6 "2020-06-05T02:53:45Z")

</div>

Got it. That makes sense.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [June 5, 2020, 8:45pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/8 "2020-06-05T20:45:23Z")

</div>

Hola @ThinhDinh

If you use coordinates, you can use more than 10 map pins on your free APP. Here is my test:

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

Saludos

---

<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 5, 2020, 9:15pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/9 "2020-06-05T21:15:27Z")

</div>

Is there a limit on this? Thanks a lot!!

---

<div class="post-metadata">

### Author: ![Gliderrr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gliderrr/32/5215_2.png) [@Gliderrr](https://community.glideapps.com/u/Gliderrr)
#### Post date: [June 7, 2020, 7:51pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/10 "2020-06-07T19:51:21Z")

</div>

Love it! Very useful for map & distance centric for sure 👍

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 8, 2020, 6:48pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/11 "2020-06-08T18:48:03Z")

</div>

Two user-specific columns feeding two single value columns and one distance column allows me to filter 15000 addresses to those that are within a _x_-mile radius.

[https://www.loom.com/share/eaa448418022410caa396b202c5d5212](https://www.loom.com/share/eaa448418022410caa396b202c5d5212)

Video Link: [https://www.loom.com/share/eaa448418022410caa396b202c5d5212](https://www.loom.com/share/eaa448418022410caa396b202c5d5212)

---

<div class="post-metadata">

### Author: ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)
#### Post date: [June 12, 2020, 11:33am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/12 "2020-06-12T11:33:21Z")

</div>

Hi Robert. Any chance of seeing the sheet & app structure behind how you did this?

Thanks

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 13, 2020, 2:44am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/13 "2020-06-13T02:44:02Z")

</div>

Here’s how!

[https://www.loom.com/share/1e9f704e8a604ab58d2a458de33669fc](https://www.loom.com/share/1e9f704e8a604ab58d2a458de33669fc)

Video Link: [https://www.loom.com/share/1e9f704e8a604ab58d2a458de33669fc](https://www.loom.com/share/1e9f704e8a604ab58d2a458de33669fc)

---

<div class="post-metadata">

### Author: ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)
#### Post date: [June 13, 2020, 12:09pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/14 "2020-06-13T12:09:22Z")

</div>

That’s great. Thanks Robert. That’s all clear.  
Out of interest where did you get your base data from for the list of clinics?  
Thanks

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 13, 2020, 12:33pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/15 "2020-06-13T12:33:31Z")

</div>

Client had entered them. I surely didn’t import them 😉

---

<div class="post-metadata">

### Author: ![John](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john/32/12599_2.png) [@John](https://community.glideapps.com/u/John)
#### Post date: [July 12, 2020, 3:35am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/16 "2020-07-12T03:35:34Z")

</div>

@Robert_Petitto How did you use 15,000 addresses when the limit is 1,000 map pins? Your help would be really appreciated.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [July 12, 2020, 4:01am UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/17 "2020-07-12T04:01:31Z")

</div>

I’m never displaying all pins at once!

---

<div class="post-metadata">

### Author: ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)
#### Post date: [July 19, 2020, 6:11pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/18 "2020-07-19T18:11:50Z")

</div>

@Robert_Petitto  
I have a similar list of places (E.g. place names and addresses) and, when looking at the details of one specific location I want to be able to add an in-line list that also shows ‘nearby’ places, where the other ‘nearby’ places are from the same list. For instance filter the in-line list of nearby places to within 4Km of the address of the place details being show.  
Do you know how I could go about this? Is it a relation to itself and then pull in addresses and have a distance column? I have tried this but can’t work out how to do the relation part!

---

<div class="post-metadata">

### Author: ![christoph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christoph/32/22794_2.png) [@christoph](https://community.glideapps.com/u/christoph)
#### Post date: [September 27, 2020, 8:29pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/19 "2020-09-27T20:29:10Z")

</div>

Thank you Robert for your great video, it really helped.

From my experience the zip code needs not to be in the same table because the Single Value function can also work with values from other tables.

I’ve also realised, that if you want to calculate a distance with 4-digit zip codes (as we have them in Austria), the calculated values are wrong, but it works great if you add a city name to the zip code.

---

<div class="post-metadata">

### Author: ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)
#### Post date: [September 28, 2020, 7:38pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/20 "2020-09-28T19:38:45Z")

</div>

That will be the case since many other countries use 4-digit ZIP codes (Australia, New Zealand, etc.)

I think if you just append the country name to the ZIP code, you will get a lot more accurate measure of the distances.

---

<div class="post-metadata">

### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [October 14, 2020, 9:24pm UTC](https://community.glideapps.com/t/distance-column-officially-available/10318/21 "2020-10-14T21:24:57Z")

</div>

Excel has a way of interpreting zip codes into coordinates as well as states, counties, countries, cities, etc. just put the list in excel and click the geography button as the column is highlighted and it will do the rest.

[Next page](https://community.glideapps.com/t/distance-column-officially-available/10318.md?page=2)
