Work Orders 2
Employees can use this app to request repairs and fixes. Cool features include workflow, calendar, dashboard, and format rules to highlight priorities.
Function: Field Service
This app is an upgrade version of the Work Orders app. This handy app helps manufacturing employees request work orders for parts that need repair or replacement. The employee can enter their information, name of the part, details and priority of the issue. The repairman can then update status (Submitted, Assigned, In Progress, and Resolve) and sign once the repair or replacement has been made. The app user can: - Submit a request with details of an issue--location, images, description of the issue etc; - Assign the request to a technician; - Mark priority of the issue as Low, Medium, or High; - Update and monitor status of the issue; - View progress on a calendar. Different colors on the calendar mean different locations. The app has the dependent dropdown feature, which allows you to limit the values displayed in one dropdown based on the value you selected in another field. For example, if you choose Marylee Milot in the Requested By field, the Role field will be automatically set to Foreman. If you choose Gertrude Falkowski, the Role field will be Operator. Workflow emails are sent automatically upon each change in status. When an order is submitted the manager is notified. The manager may then assign the job and email the worker. The Manager will receive an email when the work is in progress and again when completed.
Also see: tablet mode & fullscreen mode
How we built this app
We built this app using the following AppSheet features: Enums, Slices, Grouping in UX views, Column Order in UX views, Signature capture, Calendar view, and Workflows. Look for the following in this app: Enums This app uses Enums in order to indicate the status and priority of the request easily with a drop down. In order to do this, go to Data-->Column Structure, select "Enum" as the column type, then enter the options you'd like your users to select from. Randomly generated key Each order needs to have its own unique order number, and this row can also be used as the key because each entry will be unique. We did this by inputting 'UNIQUE()' into the Initial Value field. More on that: https://help.appsheet.com/data/keys/what-is-a-key Slices We created slices in order to show a view for the issues that are open and those that are resolved. In order to do this, go to Data>>Slices, and add New Slices. We use the following expressions to indicate the slices we wanted to create: [Status]=In progress, [Status]=Resolved. In order to include these views in the app, go to the UX tab and create new table views for each of these. Grouping and Column Order in UX We used grouping in the app in order to make the records easier to navigate. We did this by navigating to the UX tab, and within the view for All Records, we selected Group By: Date in ascending order. In the same section, you'll see the option that indicates Column Order. You may rearrange the columns to the order you require. Signature Capture Included in the spreadsheet is a Signature column which was automatically recognized by AppSheet. This allows users to input a signature and indicate that the work order is complete. Calendar view The Calendar view shows the number of days taken to resolve the reported issues. The Calendar View provides your app users with an intuitive way to view any events, project deadlines, reminders, daily routines, customer meetings & more. https://blog.appsheet.com/calendar-view Workflows Workflow emails are sent automatically after each change in status. When an order is submitted the manager is notified. The manager may then assign the job and email the worker. The Manager will receive an email when the work is in progress and again when completed. More information on workflows may be found here https://help.appsheet.com/behavior/workflow-sending-email/sending-email-from-a-workflow-rule-or-scheduled-report. A ChangeTimestamp is used to record when each change of status is made. Further Information on app design can be found here: https://help.appsheet.com/app-design/app-design-101.
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.