Template
Work Orders 3
A work order app in which employees can request repairs and fixes.
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 of the issues and priority of the issue. The repairman can then include status and a signature once the repair or replacement has been made.
The app user can:
- Submit a request with details of an issue
- Indicate priority of the issue. Orders can have one of three statuses: Low, Medium, High
- Monitor status of the issue as the repairman makes changes and view progress on the calendar. There are four job stages : Submitted, Assigned, In Progress and Resolved.
Loading...
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, we navigated to Data, then Column Structure and selected "Enum" as the column type. We then manually entered the options we'd like our 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 here:
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, we navigated to Data, then Slices and added New Slices. We then used 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, we navigated to the UX tab and created 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 help with App design.
Further Information on basic AppSheet design may be found here.
https://help.appsheet.com/app-design/app-design-101
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...