Good day from Kentucky!
I am not sure how to explain my problem, so bare with me.
I am creating a dispatch type app. I have a master sheet of ‘trips’ that is filled by information from 5 other sheets (i.e. drivers, clients, addresses) and I have created views for a dispatcher (dashboard with slices of trips that shows all trips, trips today that have a driver assigned, and trips today that do not have a driver assigned) and a driver (slice of trips where the driver is unassigned).
In my address table, I have addresses and their geocoded lat.long. When a dispatcher uses their ‘trips form’ all the information is added and pulled in accurately. However, when my driver updates the same trip (identified by a unique key), all the data remains except for the lat.long column. It sets it to 0.00, 0.00. The only column the driver updates is the pick up time and drop off time.
Any direction would be great. If I need more info in here to explain my issue - just let me know.