This handy app is especially useful for making equipment inspections in manufacturing or factory work, and lets the user collect data about equipment status and repair needs.
You can copy and customize this app for free. Add more columns to manage different categories, add formatting rules to the app, or enrich it with many more AppSheet features!
Inspections & Surveys
A mobile app for manufacturing equipment inspections.
This app takes advantage of the following features:
The Table UX view allows for grouping in the app. You will see the first level view only displays the buildings. When you click into a building, you'll then see only the equipment surveyed in that building. When you click into a piece of equipment, you'll then see the equipment grouped by whether it was marked satisfactory or not. Clicking items in that view then renders the whole record.
Every time a record is submitted, the timestamp is automatically recorded.
Timestamp is usually a great key column, however in this instance we had multiple inspectors submitting reports at the same time. Thus we set the key as a combined key of columns Timestamp and Inspector.
You'll see two red dots by Building B and Building C in the main Inspections view. From the UX>Format Rules tab, we created a rule that shows a red dot next to all the buildings that contain equipment that was marked unsatisfactory.
Delete my account
Create a new App
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.