Format Zip Codes

[Trisha_Poole2]

I'm looking for a workaround to populate the distance between two zip codes. I need to identify which office is closer for each employee. I have input all the zipcode coordinates with a linking structure in the base. 

https://airtable.com/shrwDRIKVyoBphDBk/tblNsf1iP5agssIZS/viw5teuUhoedEPQA6?blocks=hide 

The excel formulas I would use don't work in Airtable. See the formulas in the base under the "Miles to office ONE" and "Miles to office TWO"

I'm a beginner when it comes to formulas in Airtable so I'm hoping someone can help. I don't have any experience with JavaScript or coding. 

[WilliamPorter]

I did something like some years ago in FileMaker using the Google API. Have not done it yet in Airtable but working with the Maps API in Airtable should be similar. Did a quick search. This is an old article but I bet you can find something more recent.

https://www.cyberscorpion.com/2012-09/calculating-the-distance-between-zip-codes-using-the-google-ma...

Responding because nobody else has yet, and just want to say that I'm pretty confident it CAN be done. (Perhaps somebody's already done it!)