This app, used together with the Driver Jobs app lets a team manage a list of jobs. The dispatcher creates jobs in the app, which can be opened in any browser. The jobs created will be updated via the Driver Jobs app which shows a filtered list of jobs to the driver.
A sample app to create a list of jobs for field workers.
We built this app using Smartsheet and AppSheet in under 30 minutes. This app uses Grouped Lists, Maps, and default values to help dispatchers create new jobs. We also used formatting rules to identify each customer in the lists.
1) Grouped lists: All jobs are showed in a view in the app. The view is available via the UX menu. We selected List type and action type Grouped. We grouped by driver to get a clear view of the different jobs each driver has.
2) Each customer has an address. AppSheet automatically included a map view listing all the customers.
3) We created formatting rules for each customer. We first created a set of slices in Advanced Editor > Data > Slices where each slice matches the name of a customer. We then went to Advanced Editor > UX > Formatting and created a rule for each slice. We changed the color of the Job ID, Address, and Appointment Date.
Copy this app and the Driver Jobs app to create your own solution to keep field workers connected.
Choose a Sheet
To find the ID of a sheet, go to the Smartsheet site, open the Properties of the sheet, and copy the ID property.