Lets use Latitude and Longitude to get the addresses
We will need to add some new fields
Add a Status field (Multiple choice) and additional Address field
Adding statuses will allow us to process records in stages
We also need a trigger, which will be a formula checkbox
Here's the full formula for Reverse Geocode Trigger
Lets create the Quick Base Pipeline to call the API. The trigger will be a Work Order record updates, where Reverse Geocode Trigger = true
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
Here we specify all fields we'll need
After we have our list of fields we need, lets set the trigger's initial checks and balances
The criteria: Reverse Geocode Status is Pending and Reverse Geocode Trigger is true
Now that the conditions are safe, lets make the API Request!
For this we'll go with a basic HTTP(s) request using a structured URL and API token
I found this URL in the API docs, add Latitude and Longitude fields in place
Copy your API Keys and paste it
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
Works!
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!