An app for construction site inspections with GPS and images.
How we built this appWe created this app with with Google Sheets and AppSheet. It uses a some powerful formatting and data capture features: 1. Automatically captures GPS locations: Check the Data > Column Structure > Location field an see how we configured that column to automatically capture data that can be mapped 2. Collect images: We added two columns called Picture 1 and Picture 2. AppSheet Automatically recognizes the type of field and gives an Image input option 3. Created slices to further customize the app: Go to Data > Slices and you'll notice three slices. We created those slices to filter the data by the "Site Type" column. We'll use those slices to change the formatting of the data. 4. Changed the color and icons of the sites: Go to UX > Formatting and see how we created different formatting rules applied to the slices we initially created. TYPE A buildings have a Green style, TYPE B has Blue ,TYPE C has Yellow. 5. Added a customized Map View (Locations): Go to UX > Controls and you'll notice the different views we created for the app. We added a map view and used three extra formatting rules to also change the color of the pins. This is very useful for project management to quickly visualize the status of different items in a map. Pro tip: Apply different formatting rules to the same slice to get different effects. In our case, we applied a formatting rule to the Site Name column and then applied a formatting rule to the Location column.
Inspections & Surveys