Calculate distance between two points, populate custom field
I have a full address field and a distance field. I would probably initially perform a bulk-op, but would want to set up a workflow.
The workflow would probably look something like this:
Trigger: New contact added
Filter:
If "full address" exists
Action: populate distance in miles in "distance" custom field
Goal: If contact address changes (or Full Address field is populated for the first time), calculate distance again and update distance field.
My use case is that I have a brick and mortar store and want to be able to do some hyperlocal marketing, including automated mailers and SMS/email to drive foot traffic.
-
Tim Berman commented
If PlusThis integrated with ZipCodeAPI, this is totally possible! It is a free API tool.