How to make addresses show correctly in glide app map component

Dan Liebeschutz
May 12 · 1 min read

In glide app, there is sometimes a problem with showing addresses correctly on the map component after choosing the right location column in our source spreadsheet. This is me trying to put four addresses in Tel Aviv, Israel:

Glideapp map — Me trying to put four addresses in Tel Aviv

First step: Build a custom function in the script editor

We will first build a custom function in the source spreadsheet with google apps script that gets as an input an address and returns latitude and longitude. You can copy this code to the google spreadsheet script editor:
(An article on how to use this script in your google spreadsheet)

These pills can effortlessly be secured from the online drug suppliers deliver these products in a discreet packaging. cheapest levitra It is used after mixing in a glass of water. viagra side online In that tenure, the Giants finished a game over .500 in buy levitra wholesale the strike-shortened 1981 season. Men often get sexual arousal which automatically invites female cialis online masturbation.

Second step: Use the custom function in google spreadsheet

Then we will use the custom function and put the address cell inside as an input. Let’s say the cell containing the address is C2 and we want the coordinates to be in D2, so we will put in D2 the following:

=GEOCODE_GOOGLE(C2)

Bonus step: Use the custom function with ARRAY FORMULA

In order for the formula to work all through the column with added rows from form entries or whatnot, you can copy this formula and paste it in the first row of column D. Make sure that all data from the following rows in column D are deleted, otherwise, the array formula will not work.

=ARRAYFORMULA(GEOCODE_GOOGLE(C2:C))

How to make addresses show correctly in glide app map component