If you have a Property Management business you may ask tenants to accomplish a move in checklist/inspection of the unit to allow them to document any property damage as a sign of good faith so they can protect their security deposit. While a paper checklist can be used for this task, paper forms lack the ability to capture pictures and automate the capture of this important information for both the tenant and landlord. If you run a property management agency, using a paper form becomes another administrative burden to track and manage. Taking 3-4 hours to develop a simple Move-In Checklist app for your tenants will save your business time in the long run.
This is the second part in a two-part series. The first part gave an overview of how the app works. This post will cover how to make the app on the AppSheet platform.
Part 2: Making the App
The post assumes you understand the basic funcitonality of AppSheet and how to use it. If you are just learning about AppSheet please check out this video for a good first primer on how to use the platform. You will also find several other resources that will help you to learn and leverage this powerful tool.
Data Tables and User Settings
3 tables will be needed to record data for this app. Inspections, Locations, Location Pics and a couple of User Settings columns. The Inspections table maintains the top level data for each inspection while the Locations table will record the specific details for each location such as “Dishwasher” or “Master Bedroom”. The Location Pics is a simple table that will store the picture data for each of the Locations in the “Location” table.
The Inspections tables will have the following columns and types. This table is used to record the top level inspection data for each move in checklist. Location of the checklist, Names, contact info, basic lease agreement, and status of the inspection and the Completed date. The “Related Locations” column will be automatically generated when you create the reference column in the following table. The “Complete” column is used to give the user a message on whether the checklist is Inprogress or Compete. You can use this formula to create that message.
=if([Status]=”Complete”,”Checklist Complete!”,”Checklist Inprogress”)
The next table you will create is the locations table. This table records each of the individual rooms or appliance condition for each inspection. As mentioned above, the “Agreement ID” column should be a reference column referencing the “_ComputedKey” column from the Inspections table which will create the “Related Locations” column in the prior table. The “_ComputedKey” in this table is the concatenation of “Agreement ID” and “Location” columns. The other columns are straight forward with one I would like to emphasize. The “Ref_Pic” column is virtual and will reference the next table “Location Pics”. This is important so we can keep a static set of pictures for each type of location at a specific property. Here is the formula to use for this
=lookup(lookup([Agreement ID],”Inspections”,”Agreement ID”,”Address”)&[_thisrow].[Location],”Location Pics”,”_ComputedKey”,”Image”)
The last table is “Location Pics”. As covered above, this is the table that simply records the pictures for each specific location. The “_ComputedKey” is just a concantenation of “Location” and “Address.”
Next, the User Settings should be 2 columns that record text inputs “Agreement_ID” and “Last Name”. These will be used as a security filter to prevent any other user from seeing other tenant data. The Inspections and Locations tables should have a security filter that filters out all data that does not have those two User Settings.
Slices, Views and Actions
Now that we have the data structure
The “Move In Checklist” view is what you are expecting, the actual checklist that the tenant will be using.
The actions in this view are what gives the user the ability to mark locations as “Good”, “Damaged” or will give the ability to “Undo” if they accidentally hit any of the prior two actions. The “Good” action marks the “Status” and “Condition” columns as “Complete” and “Good” respectively. The “Damaged” action marks the “Status” as “Awaiting Details” and takes them to the “Edit” view form. “Undo” is simply an action that clears all of the fields so the user can re-input if needed. After
The “Finalize” view
Move In Checklist for Agreement <<[Agreement ID]>>
Tenant: <<[First Name]>> <<[Last Name]>>
Lease Start: <<[Lease Start]>>
I have inspected the property at <<[Address]>> for the items listed in the preceding checklist. I certify that the above record is accurate.
<<[First Name]>> <<[Last Name]>> | <<[Date Complete]>>
That’s it! Creating simple apps is that can make your customers interactions simpler and can pay huge dividends, not only for the professional
If you like the concept of low-cost mobile tools for your business, but do not have the time to create an app, CryptoCoach provides a service that will develop custom tailored apps for your business workflow. Please contact email@example.com or call 707-200-7978 for a free consultation.