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.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |