Template
Project Mgt App 2
An app to update project status and view progress on a calendar.
The Project Management app is designed for teams to keep track of all projects in one place. With the app, users can assign tasks, track progress, view tasks by custom groupings (by status or by owner) and add updates.
The app has two calendar views. The Anticipated Timeline view shows projects by week. Colors are project status indicators.The Actual Timeline view displays projects by month.
The app also has dashboard views. The All view shows Anticipated Timeline calendar, projects by owner, projects by status, and project details. This dashboard is on interactive mode, meaning once you click on a project on the calendar, a project will be highlighted on the By Status view, the By Owner view, and the Details view. Check out the Dashboard view and the Timeline Dash view for other view combinations.
The app's workflow notifies project managers on project status updates. Its action feature allows users to update status to Complete by clicking on a button.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We built this app with a set of descriptive columns that provide important information about the specifications of each task, including the Owner, Status, Progress, and more.
Special column types allow users to view each task and immediately discern what has been completed vs. what’s left to complete.
--First, we created a set of tasks in the spreadsheet as indicated by the first column in the “All” view in the app.
--We created a set of progress markers as a dropdown menu (or Enum Field Type) for the Status field including Not Started, In Progress, Delayed, and Complete.
--We created dropdown menus using the Enum Field Type for "Owner" and "Assigned To" as well. This way, users do not have to manually type in employees’ names.
--The Calendar view shows the anticipated and actual start and end dates for the tasks. More information about calendar views may be found here. https://blog.appsheet.com/calendar-view
--The dashboard view allows you to show multiple views in one place. Currently Calendars, Maps, Charts, Gallery, Deck, Table, and Detail views can be added to a Dashboard. If the view content is related or from the same table as data in other views, enabling 'Interactive Mode' allows content to be dynamically updated as different entries are selected. On a tablet or desktop, the dashboard views are adjustable and may be repositioned by drag and drop as well as expanded.
--Updates are added to each task to track progress and developments. The USEREMAIL() of the task update is collected along with each update and the date time. There is also a column for the updater’s signature.
Further Information on basic AppSheet design may be found here.
https://help.appsheet.com/app-design/app-design-101
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...