I am wanting to make a personal Mileage tracking app. I have used Google forms to keep track of data currently and I am using a Google script that works to calculate the mileage from one physical address to another using Google Maps. I have to go into sheets and copy the formula to all new fields. Just looking for an easier way. Any thoughts?
We recently built a slightly different example for someone who had a mileage problem but also wanted to track when to change their car oil. I suspect this example might be a good starting point for you. Here is the example app:
If you choose “copy app” you can continue designing it as you see fit. Here was the original post for that other use case: Cell value based on numeric increments
and if you search these forums for “mileage” there are also a few other examples and ideas.