A sample app to create a list of jobs for field workers.
Function: Field Service
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.
Also see: tablet mode & fullscreen mode
How we built this app
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.
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.