Acquire latitude and longitude from address using Google Maps API.
Obtain the API key in advance from the Google Maps site. To obtain an API key, please refer to the instructions
https://developers.google.com/maps/documentation/javascript/get-api-key?hl=ja
provided.
Place a Blank space field where you want the buttons to be displayed in your app. You can have latitude and longitude in separate fields or in the same field.
Set API key, Address, Latitude Field, and Longitude Field.
Enter the API key of Google Maps.
You can obtain the API key from the Google Maps site.
https://cloud.google.com/maps-platform/?hl=ja https://developers.google.com/maps/documentation/javascript/get-api-key?hl=ja
Enter the address for which you want to obtain the latitude and longitude.
If the field includes address information, you can use an expression to pass its value. If the fields are divided into “Prefecture,” “Address 1,” and “Address 2,” specify them as follows.
${Prefecture} ${Address 1} ${Address 2}
When specifying an address, you can provide detailed information down to the block number, or you can use a general address such as the name of the city or town. For well-known buildings, such as the “Tokyo Skytree,” it is possible to display only the name of the building. This is one of the features of Google Maps.
Select the field where the obtained latitude data will be saved.
You can select a Text or a Number field.
To store latitude and longitude in the same field, please choose a Text field instead of a Number field.
Select the field where the obtained longitude data will be saved.
You can select a Text or a Number field.
To store latitude and longitude in the same field, please choose a Text field instead of a Number field.
Latitude and longitude are stored in the same field as comma-separated values:
34.6937, 135.5022,
as shown in the example.
When specifying fields (columns) in the table for the latitude field and longitude field, it retrieves the latitude and longitude for each row of that table. Due to the limitations of the Google Maps API, data retrieval occurs at intervals of approximately 2 seconds, as the API cannot process large amounts of data simultaneously.
Consequently, it will take some time before all data is acquired. During this period, any edits made by the user on the screen will be lost, and the content will revert to the original state before the latitude and longitude acquisition begins.
When obtaining latitude and longitude for fields in the table, it is recommended to implement a loading screen to prevent user input during this process by using the “Display Loading Screen” action.
This action does not allow the option “When user clicks the pencil on the List Page” in the condition “When Fields Value Changed.” The process does not result in any errors; however, no addresses will be exported.