Hi! For our business, we use an app for our drivers as they do their route, picking up compost from customers.
We have a section or tab on the app called Driver Time Log, where drivers can type in their name, the dayโs date automatically fills, as well as the time of the entry creation. They then can edit the entry when theyโre done to add the time they end their route and add any notes they want. All this data syncs to a sheet in our Google Sheets, labeled Driver Time Log. So it can be seen on the app but also on the Google Sheet.
Now Iโm trying to add a drop down section called Action, where the driver could select a list of activities (lunch, truck prep, Route 1, Route 2) so that we can know what they did during the time entry. Ideally, Iโd like to have it show up in the form, when they fill out everything else, and Iโd like for their selection to sync and show under the Action column Iโve created in the Driver Time Log Sheet.
So far Iโve been able to create a drop down menu through AppSheet by setting the column Action to type Enum. It works in the app. Drivers could select an action while filling out the rest of the time log, but the choice doesnโt sync up to the Google Sheet, like the rest of the data does.
Any advice? Thank you in advance!
LinkedIn
Twitter
