An app for contractors to track projects, including costs and progress shown via a chart.
How we built this appWe built this app in under two hours. The contractor app includes Charts, grouped lists, and conditional formatting to help the user navigate the data. Here are some design highlights: 1. The app contained numeric data and formulas in the spreadsheet. We decided to show a chart that compared estimated and actual costs by going to Advanced Editor > UX > Controls and added a view of type Chart - Col Series. AppSheet automatically built an app using columns with numeric data, we then selected a second column in the new view to compare two data points. 2. We grouped the sheet by status and by Area using the UX view and selecting the appropriate grouping method when selecting List - Grouped. 3. We added conditional formatting to show Complete projects in green and Not Started in Red. To achieve this, we went to Advanced Editor > Data > Slices and created two slices. One to for data when status equals Complete and one when status equals Not Started. We then went to Advanced Editor > UX > Formatting and created two formatting rules, one called Complete that pointed to the slice showing complete jobs, and another one pointing to the slices showing not started jobs. To learn more about formatting, go to: https://appsheethelp.zendesk.com/hc/en-us/articles/206122068-Conditional-formatting Copy this app for free and customize it with your own branding and projects!
Planning & Project Management