Template
Maintenance Repair
This app allows a repair person to service tenant maintenance requests.
Industry:
Real Estate
Function:
Operations
This app allows a repair person to document tenant repairs. Special features enable the repair person to include photos and obtain the tenant's signature.
Two partner apps provide additional functionality: 1) app for tenants to submit repair requests and 2) app for landlord to see an overview of all requests and their current status.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We built this app using Google Sheets and AppSheet.com.
1. Since this app uses the same data as the Maintenance Request app, we simply copied the Maintenance Request app and adjusted the format for the Maintenance Repair purpose.
2. In the Maintenance table we verified that our primary Maintenance table had the proper settings, i.e. the table was changed to UPDATES only. Next, we removed the request field requirements and unhid the repair fields.
3. In this app, the repair priority is now visible. The repair priority is based on issue urgency: Critical (to be addressed immediately), High (to be addressed w/in 24 hours), Medium (to be addressed within 72 hours) and Low (to be addressed within 10 days). We also elected to use a Color column type to display the same priorities for easy identification by Red, Orange, Green, and Blue, respectively. The Priority and Color are derived from the Issues table via a De-reference.
4. The repair status is also displayed. Status begins as Requested, Assigned, Scheduled, Parts Ordered, and finally Repaired. We used Progress Harvey Balls to quickly the status. The Status and Progress are generated from If_Then statements.
5. The default Repair Person is set as "Unassigned" via the Maintenance Initial Value. The Repair Person is assigned by the Landlord in the Maintenance Overview app. The Schedule Date is also assigned by the Landlord in the Maintenance Overview app.
6. The Repair Person is responsible for logging the repair or if parts need to be ordered for the repair.
7. Comments may be added to the repair, along with a repair showing repair completion.
8. Finally, the Tenant indicates if the repair was satisfactory and signs the record.
9. We created a Repair view with a Repair icon for this app.
10. This view groups the records by Repair Person and lists the units according to Priority and Status.
11. The repair person selects the specific request and submits the necessary updates.
12. That's it. Now you have online and real-time maintenance repairs documented.
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...