An app for a delivery driver to keep track of deliveries based on delivery status.
How we built this appDelivery Tracking We built this app with a Google Sheet. 1. The Address column produced a Map view in the app. You can also manually create a map view via the UX tab. Clicking into each entry will also display a map pin that can be clicked to navigate to that location on the map. 2. The Signature column in the spreadsheet created a Signature Field Type in the Editor and the app. When the “Edit” button is clicked, each entry has a field where the delivery recipient can sign her name to indicate she has received the delivery. 3. The Delivery Time column activated the Time column type in the app. 4. We wanted the delivery driver to have the ability to indicate the Delivery Status by quickly choosing a corresponding color in the app: green for “delivered”, yellow for “in transit”, and red for “not delivered”. We chose “Color” as the column type for this field. 5.. We created a set of conditional rules that display colored icons corresponding to the delivery status color. First, we needed to create a slice for each delivery status— Yes, No, and In transit. Then, we created a set of conditional formatting rules, indicating the highlight color, the icon, and the column next to which to display those attributes.