Google Places Autocomplete Plugin

Designed by Oracle APEX developers, for Oracle APEX developers.

Features

Return address into multiple items

Return address into Interactive Grid columns

Return address JSON

Create a Dynamic Action

• Event : place_changed[Google Address Autocomplete]
• Selection Type : Item(s)
• Item(s) : <autocomplete plugin item>

On True:

• Action : Execute JavaScript Code
• Code : console.log(this.data)

You can access the JSON with this.data. The size of the JSON is dynamic based on the users input. If a city is entered, you will not receive route, street_number, etc...

Example:

{
  administrative_area_level_1 : "New York"
  administrative_area_level_2 : "Clinton County"
  country : "United States"
  lat : 44.697461
  lng : -73.466204
  locality : "Plattsburgh"
  postal_code : "12901"
  postal_code_suffix : "2727"
  route : "Beekman Street"
  street_number : "46"
}

Note : This only works for the Page Item and not the Interactive Grid for now.

Installation

1. Download the item_type_plugin_com_insum_placecomplete.sql file.
2. Import the plugin into your application.
3. During installation, enter your Google Maps Javascript API Key. If you do not have one, you can acquire one here: https://developers.google.com/maps/documentation/javascript/get-api-key
4. Enjoy!

Pricing

Google has limits on the amount of requests per day that you can make for free. This plugin uses the Google Maps JavaScript API. Please view the pricing table to determine if you will need to enable billing: https://developers.google.com/maps/pricing-and-plans/#details

Changelog

See changelog.

Project Sponsors

Insum Solutions

Team

• Neil Fernandez
• Martin D'Souza