I’m not sure if this is possible in an AppSheet app. If it is, I’m hoping someone can steer me in the right direction to make it work.
I’ve created an app for client that delivers newspapers to stores 7 days a week. This app is pretty basic. It has each of the stores contact info, the route number, and the quantity of newspaper that gets delivered each day. This is what I’ll call the main Admin app.
What I’m working on now is an app for drivers to tie into the Admin app to get the route info, quantity and store location, and delivery sequence. This is fairly simple to do. Using a routing program I can sequence the route to make the deliveries efficient for the drivers. I’ve figured out how to show the quantity for each day. I can get the app to capture date and time and GPS. What I’m trying to figure out is if there is a way to reset the data so the sequenced data shows up as new every day.
I’ve currently got the Driver app to work like this: A driver logs on and sees a detail view, which is store location name, delivery quantity, and delivery sequence number 1. The driver will click on the “map” action icon to get guided directions to the store. Once the delivery is made the driver clicks on the “Delivered” action icon. Once sequence 1 is delivered, sequence 2 should appear in the detail view. I currently have the Delivered action tied to a delivery excel file to keep track of all deliveries. But I can’t figure out if there is a way to reset the data so when the driver logs on the next day, the sequence starts back at 1 again.
Hopefully this make sense. Thank you in advance for your help.