By: Neil Fernandez On: February 06, 2018 In: Uncategorised Comments: 0

Recently I was working on a project that relied heavily on location data. It required entering addresses, over and over again. Country, state, street address, city, zip code, etc… I was thinking that there must be a better way. Turns out there is: Google Autocomplete!

I am sure you have seen stuff on the web that looks something like this:

Google Places Autocomplete advantages

This type of address input has a few advantages over allowing the user to type whatever they want. First, it gives you valid addresses from the Google Maps API. Second, it speeds up the process for the user because they don’t have to type out all the address fields. It even gives suggestions based on their location! And finally, it is just pretty darn cool.

Now with our Google Places Autocomplete Plugin for Oracle Application Express (APEX) , you can get up and running with this in just a few minutes.


  • Ability to map address components to multiple items.
  • Ability to limit the search to different address types such as addresses, establishments, cities, and more!
  • Interactive Grid (Grid example)
  • Option to return abbreviated form of Address, State, and Country.
  • Option to return address in JSON format. (JSON example)
  • Suggest addresses closest to user’s current geolocation.

(Grid example)

(JSON example)

Google Places Autocomplete saved me a lot of time

Using this feature cut my address input time from 12 seconds to 3 seconds on average. It may not seem like a lot, but when repeating this process, it allows users to complete the task in only one quarter of the time that it usually does. That is a huge improvement in terms of time and also just the overall experience in general.

A few tips on installation of this plugin

To install this plugin, go to our github:  https://github.com/insum-labs/apex-plugin-google-places-autocomplete
First download the repository. Then open APEX and go to the app you wish to install it in. Import the plugin file named “item_type_plugin_com_insum_placecomplete.sql”. After the import is done, it will ask you for an API key which is required. You can acquire one at https://developers.google.com/maps/documentation/javascript/get-api-key. That is all that it takes!

Finally, if there are any issues or enhancements you would like to request, please submit them on the github page and we will respond to them in a timely manner!