Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

New Data Type: Location

cancel
Showing results for 
Search instead for 
Did you mean: 
Jacob_Clayton
5 - Automation Enthusiast
5 - Automation Enthusiast

Could you add a new data type for locations? Types of locations that would be useful are:
-Address (123 First St, City, State)
-Lat / Long (31.12345, -110.12345)
-Military Grid Reference System (11S NV 12345 12345)

This would be incredibly useful if the location is a hyperlink to a map (similar to how an address in the Long Text data field will open up in Apple Maps).

Additionally, if a list of locations on a table could be viewed in a single map view allowing the map to display all of the locations from the table.

105 Comments
Elly_Hanrahan
4 - Data Explorer
4 - Data Explorer

This seems like it would really help us! Would you be able to explain your formula a little more? Also, what format do you input into the ‘address’ field?

JJ_Trujillo
4 - Data Explorer
4 - Data Explorer

Yes! a “location type” with address, city/state/zip would be a great help with our mailing list.

Erika_M1
4 - Data Explorer
4 - Data Explorer

Elly, Alexey’s formula works as follows (I am going to use restaurant names for my example):

  1. First create an column for the restaurant names (we will call it “Restaurant”)
  2. Create a 2nd column (I will refer to this as the “google maps link”) and add Alexey’s formula (which I changed to the following):
    IF(Restaurant=BLANK(),BLANK(),CONCATENATE("https://www.google.com/maps/search/",SUBSTITUTE(Restaurant," “,”+")))

Here is the breakdown:

  1. IF the “Restaurant” name is blank, then return blank for the “google maps link”
  2. IF the “Restaurant” name is NOT blank, then return the following string of text together: https://www.google.com/maps/search/restaurant+name
    *For a google maps link to work there needs to be “+” in between each space of the name of the place you are searching, hence the substitute() formula.

Hope this helps

Anurag_Singhai
4 - Data Explorer
4 - Data Explorer

+1
a simple (lat-long) data type with a map_view on Open Street Map would be super useful.

Kevin_Cole
4 - Data Explorer
4 - Data Explorer

Currently, geocoded addresses are saved as a base64 encoded string. However, there is no support for decoding base64 to a normal string, making it difficult to access the returned latitudes/longitudes. It would be great to have a way to save lat/lng values as strings! That way, these values can be easily used for external applications.

Angela_Hale
4 - Data Explorer
4 - Data Explorer

Would love a location field - address, city, state, zip, etc, with some international support options for different international needs (like province). Doesn’t seem to be a clean or effective solution to separate them all out into individual columns (city, state, etc).

Utility_Locator
6 - Interface Innovator
6 - Interface Innovator

Voting for this, thanks!

AM858
6 - Interface Innovator
6 - Interface Innovator

Please please please include this. I love using airtable for collecting information about real estate. Here are a few use cases.

  1. Apartment Hunting: I collected about 50 different apartments into a base to share information with my roommate. It would have been really helpful to be able input the address into a field so I could click on the address to go to it on maps or see all of my data entries pooled together on one Google Map

  2. Creating lists of locations: Would be awesome to create lists of, for example, trending restaurants, which could be seen on a google map.

  3. Looking at investment property: Same as the other reasons. I’d like to be able to see properties I’m looking at buying on a map view.

Rene_Galindo
4 - Data Explorer
4 - Data Explorer

I’m creating IMDb for Tacos: The Internet Taco Database. I need location to add the restaurant where the taco is located. I’m currently using the link from the venue in Foursquare / Gmaps, but would love to add it directly from Airtable.

Cheerio,

Abram_Bailey1
4 - Data Explorer
4 - Data Explorer

Is there any way to add a new location by google address autocomplete / Google Places? We want to build a form for business registrations in our online directory, and would need something like this for Airtable to be an option.