An app to manage school work and assignments.
How we built this appWe built this app with AppSheet in under 2 hours by creating a Google Sheet and then having AppSheet automatically build a mobile app from the spreadsheet. Once the app was created we added several customizations to make the app work the way we wanted: 1. We added two tables from the spreadsheet to the app via Advanced Editor > Data > +Table One table is for assignments and the second for courses 2. We created a reference between column Course ID in the assignments table and Course ID in the Courses menu. We did this by going to Advanced Editor > Data > Column Structure. Selected "Course ID" and then changed its type to REF, when your select Ref, you get to select a table you want to reference to. Now, when you add an assignment, the Course ID will be a drop-down showing the values from the course menu. 3. We also created a set of slices to show visual clues of the status of the assignments. To create multiple slices, go to Advanced Editor > Data > Slices. We created slices based on the number of days left to the due date. We also created one slice to include everything that has been marked as Completed. Play with the different slice configurations to get to the right subset of data to show. 4. We user the set of slices to create formatting rules over our app. For example we created a rule that changed the assignment name color to RED and pointed it to the slice "Past Due" so every assignment that matches the conditions for past due (the date of the deadline is greater than today), turns red.
Data for this app
Education & Training