How to import Locations and open them in Google Maps | MoreApp

Import a location and open it with Google Maps in your form. 

No MoreApp account yet? Sign up here.

1. Create the database

To begin with, you need to create a database with all the information needed, for example: company, city, telephone, email and address.

You can create the database with Excel, Google Sheets, et cetera. Make sure that you meet all the requirements. To have an effective data import to the Platform, all the columns of the document need to have a title and the first column has to be called 'id' and needs to include a unique combination of numbers/letters.

 

 

If your document is an Excel file, make sure that it has the correct .xslx extension so that the data can be imported. 

2. Search for the location

Once you have all the information ready, it is the moment to add Google Maps' location to your database. In order to do so, look for the address that you want to add to your database on Google Maps. You will need to use only the part of the link that includes the link to Google Maps (https://www.google.es/maps), the name of the place and the coordinates.

Here is an example:

3. Add the location to the database

Go back to your Excel or Google Sheets database and add a new column for the location. In this column, you will need to paste the Google Maps link that you have obtained in the previous step.

3.1 Use the coordinates

If you also want to include the coordinates in your database, you can obtain them from the Google Maps link. Create two new columns, for the latitude and for longitude, where you will insert the coordinates of each location. In this example, the values will be:

  • Latitude: 37.3390289
  • Longitude: -5.9788817

 

After following all these steps, you will obtain a document similar to this one.

 

google-maps-locations-datasource-moreapp 

4. Import data to MoreApp

Log in to the Platform. Go to Data Sources tab and click Add a data source. 

You have the option of importing using different formats (access the tutorial on how to do it just by clicking the desired option):

After adding the data source, you will need to import the data by clicking Schedule import

5. Add the Search-widget

Go to the digital work order form where you want to add the data source, click Edit Form and add the Search-widget. 

Edit the Search-widget by clicking the pencil and giving the widget a name in the Label field. To finish, choose the data source you have just imported at Data source. Once the data source is selected, click Save

 Now, click Save & Publish so that your form is available to be filled out using the app.

6. Fill in the form

Open the App and open the form. Open the Search-widget and click on the info icon of the customer you want to see the location from

Once the details appear, click on the location link and you will be redirected to Google Maps.

After clicking on the link, a map will appear with a pin at the location.

Once you have seen the location within the map, you can come back to the form and continue filling it in.

7. Congratulations!

You now know how to import and open Google Maps location in your form. 

 

Want to stay up to date with our latest tutorials? Go to YouTube and hit the Subscribe button!