Calculate appointments distance

HI,

I’ve a tab with appointment (CALENDAR VIEW), and i would to calculate
the distance of the whole route every day, but i need to calculate as that:

A : OFFICE ADDRESS,
b: 1st appointment
c: 2nd appointment
etc…

LAST: OFFICE ADDRESS.

In my APPOINTMENTS table, i insert all appointments than, how can i calculate the distance for my daily Tour? I can also insert in my APPOINTMENTS tab 2 column with START APPOINTMENT and STOP APPOINTMENT to insert my location

Can you help me @Aleksi?

Hi, do you want to use columns e.g. officeaddr,location1,location2,location3
or do you want to use rows, e.g

location,position,date
location1,1,02/14/2020
location2,2,02/14/2020
location3,3,02/14/2020

Columns is easier: you can create a virtual column which is “directions” and points to google maps, an example looks like this:

https://www.google.com/maps/dir/33.93729,-106.85761/33.91629,-106.866761/33.98729,-106.85861//@34.0593359,-106.7131944,11z

you can replace those lat/longs with actual (url encoded) addresses, btw.

Is this the type of thing you were looking for?

This is good docs.

2 Likes