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.
Hi Terry,
If I understand your table structure correctly, you have a table associated with the Detail View that contains one record for each delivery an individual driver needs to make that day. The Detail View records are in delivery order. I presume the Detail View record includes a โDeliveredโ field that gets updated from โnoโ to โyesโ when the driver completes the delivery for that day.
You could create a Report (aka Scheduled Rule) that runs every day at midnight that sets the value in the โDeliveredโ field back to โnoโ.
Hi Phil,
So, Iโve got this app working almost perfectly. Iโve scheduled the delivery column to change from โYesโ to โNoโ daily, just like I needed per your suggestion. I just have one nagging issue. Since the Driver app is reading from the Admin sheet, then copying that data to a delivery sheet (for delivery record-keeping), I canโt seem to get the delivery sequence to disappear on the Driver app once the driver delivers a location.
It would be nice to do this, that way the driver can move on to the next address in the sequence without having to flip through the Detail View on every delivery. Iโve tried to use a Show_If when the delivery reads โYesโ but the Driver app is still reading the Admin data.
Iโve tried using a workflow data change, but again I somehow need to change the Admin sheet while simultaneously adding the delivery record to the Driver sheet. Is this even possible?
Sound like a great app! Is there a way I can grab a copy for a similar project. I know Iโll have to make some changes, but it would be great to not have to start from scratch.
Hi @David_Stowe
Have you had a look at some of the sample apps?
https://www.appsheet.com/SampleApps? eg
https://www.appsheet.com/SampleApps?q=tracking&hPP=100&idx=help&p=0&is_v=1
Yes, thatโs exactly what I need it to do.
Basically the Driver App pulls data from the Admin App. Once the driver clicks the delivered action button, it saves that delivery to another table to keep track of deliveries. Below is a screenshot of the Driver App that Iโm working on. It shows the sequence on the route for that store, the store name, and the delivery quantity for Monday. Once theyโve delivered to the store they click the Delivered action button and the next store in the sequence shows up in the Detail View.
Iโll look into using schedule rule. Thank you for your help!
To do this, would I need to use the webhook feature? I donโt see a function in the Reports tab to change column values per your suggested. I see a data change feature in Workflow, but that doesnโt appear to have a daily schedule.
Terry, youโll first need to create an action that sole purpose is to reset the Delivered field. The report you would run for each row of that table. Configure the time and such. Select โchange dataโ and your action should now be in a dropdown in the DO THIS section.
Ok, I see what I was missing. I needed to select ForEachRowinTable first. Doing that made the Change Data option appear. Then I was able to set the dropdown to select the action I created. Iโm sure Iโll be back with more questionsโฆ
Thank you for your help!
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |