Distance column officially available

Ask for Help
1

Official document

Glide's official announcement on Twitter

image

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.
9 Likes
2

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

1 Like
3

Yeah, but with a Pro app, obviously.

4

Why Pro only?

1 Like
5

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.

1 Like
6

Got it. That makes sense.

1 Like
8

Hola @ThinhDinh

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

image

Saludos

2 Likes
9

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

10

Love it! Very useful for map & distance centric for sure :+1:

11

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

Video Link: https://www.loom.com/share/eaa448418022410caa396b202c5d5212

5 Likes
12

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

Thanks

13

Here’s how!

https://www.loom.com/share/1e9f704e8a604ab58d2a458de33669fc

Video Link: https://www.loom.com/share/1e9f704e8a604ab58d2a458de33669fc

14 Likes
14

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

15

Client had entered them. I surely didn’t import them :wink:

1 Like
16

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

17

I’m never displaying all pins at once!

18

@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!

1 Like
19

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.

20

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.

3 Likes
21

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.

2 Likes