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.
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.