I hope I put this question in the correct area.
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.
There has to be a better way, right?