This app allows a property manager to provide timely customer service by allowing tenants to submit maintenance requests. Special features enable the tenant to include photos and comments.
Two partner apps provide additional functionality: 1) app for repair persons to document repairs and 2) app for landlord to see an overview of all requests and their current status.
An app that allows a tenant to input maintenance requests.
We built this app using Google Sheets and AppSheet.com.
1. First, we created our spreadsheet in the preferred format to support multiple maintenance apps.
2. Next from the AppSheet.com > My Apps page, we selected “Make New App.”
3. We imported all of our tables.
4. We verified that our primary Maintenance table had the proper settings, i.e. the table was set for ADDS only. Also we selected our Key field, which in this case was a combined key of Request DateTime, Unit and Issue. Next, we created our form.
5. Page one of our form contains the details of the maintenance request, i.e. the unit #, the issue, an optional photo and the expected turnaround time.
6. Page two of our form contains tenant information, if the tenant has a pet, if the tenant would like to be on-site for the repair, etc. Also included is tenant contact information.
7. Many questions in the two-page form are multiple choice that may render as a dropdown menu in the app.
8. To separate the form sections, we used Show field types.
9. To capture the exact Date and Time of the request, we used the “NOW()” Initial Value.
10. We used Ref field types and associated reference tables to lookup the unit numbers and separately the issues.
11. The Tenant and Turnaround Time were populated via reference table De-References, i.e. select the Unit and the Tenant autopopulates, select the Issue and the Turnaround Time autopopulates.
12. We gave the Tenant the option to include a description and photo and we captured the Tenant’s signature. And the Tenant provided us with necessary information so that we may do the job.
13. The table used by the Tenants has additional sections used by the Repair Person and Landlord in separate apps. Since the Tenant doesn’t need to see this information, the fields are hidden in the table.
14. And that’s it. The Tenant has the necessary expectations and the Repair Person and Landlord also have the information they need to initiate the repair.
Choose a Sheet
To find the ID of a sheet, go to the Smartsheet site, open the Properties of the sheet, and copy the ID property.