A sample app to create a list of jobs for field workers.
How we built this appWe 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 de 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 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.
Data for this app