Use Quick Base Pipelines to reverse geocode addresses with Google Maps API (Part 1)

Click here for a free 30-day trial on Quickbase. 

Contact us now to discuss setting up this application in your Quickbase. 

 

Lets use Latitude and Longitude to get the addresses

Landpick image

We will need to add some new fields

Landpick image

Add a Status field (Multiple choice) and additional Address field

Landpick image

Adding statuses will allow us to process records in stages

Landpick image

We also need a trigger, which will be a formula checkbox

Landpick image

Here's the full formula for Reverse Geocode Trigger

Landpick image

Lets create the Quick Base Pipeline to call the API. The trigger will be a Work Order record updates, where Reverse Geocode Trigger = true

Landpick image

Click here for a free 30-day trial on Quickbase. 

Contact us now to discuss setting up this application in your Quickbase. 

 

We only need one Trigger, since the criteria is inside the formula field

Landpick image

Here we specify all fields we'll need

Landpick image

After we have our list of fields we need, lets set the trigger's initial checks and balances

Landpick image

The criteria: Reverse Geocode Status is Pending and Reverse Geocode Trigger is true

Landpick image

Now that the conditions are safe, lets make the API Request!

Landpick image

For this we'll go with a basic HTTP(s) request using a structured URL and API token

Landpick image

I found this URL in the API docs, add Latitude and Longitude fields in place

Landpick image

Copy your API Keys and paste it

Landpick image

Click here for a free 30-day trial on Quickbase. 

Contact us now to discuss setting up this application in your Quickbase. 

 

Now lets turn on the Quick Base Pipeline and verify it's working before proceeding

Landpick image

Works!

Landpick image

Up Next: Part 2

Click here for Part 2 of Use Quick Base Pipelines to reverse geocode addresses with API

Click here for a free 30-day trial on Quickbase. 

Contact us now to discuss setting up this application in your Quickbase. 

 

Watch the YouTube video to see each and every step.

 

If this walk-through has helped you use Quick Base Pipelines for Reverse Geocoding, let us know in the comments section below!

 

Thanks!

Up Next: Part 2

Click here for Part 2 of Use Quick Base Pipelines to reverse geocode addresses with API

    Full name*
    E-mail address*
    Company*
    Job Title*
    Regarding*
    Message*