I am developing a base to use for a contracting business, and I have a column for Distance Driven to job (to calculate fuel used in a different column)
when I create the job for the client, it auto inputs the job address into a column, is there a way to have it auto calculate the distance to drive (by inputting my business address as always being the starting address, and the job address being the ending address?)
Currently when I am creating the job for the client in the base, I have to open Google maps in a separate page, and input my business address and job address by hand, and manually transfer the number of miles into the base.
You would simply have Airtable trigger a Make automation that uses the Google Maps “Get A Distance Matrix” module, which would then return the distance to you. That distance would automatically get sent back to Airtable.
This would all happen invisibly & silently in the background. From the user's point of view (i.e. your point of view), the distance would just magically appear in Airtable.
The only real problem is that if you've never used Make before, there is a bit of a learning curve, so it will probably take you an hour or two to figure out how to use it for the first time.
You would simply have Airtable trigger a Make automation that uses the Google Maps “Get A Distance Matrix” module, which would then return the distance to you. That distance would automatically get sent back to Airtable.
This would all happen invisibly & silently in the background. From the user's point of view (i.e. your point of view), the distance would just magically appear in Airtable.
The only real problem is that if you've never used Make before, there is a bit of a learning curve, so it will probably take you an hour or two to figure out how to use it for the first time.
