This app is designed for a student to keep track of after-school activities.
How we built this appWe first used a Google Sheet to record all activities, the days and times on which they occur, notes, and images to be associated with each. 1. We created two worksheets within one workbook: a table for Activities and a table for Notes. We added both tables via Advanced Editor > Data > Tables > +Table. AppSheet always defaults to using the first worksheet, so the first table is fine as is. To specify the Notes table, we made sure to include "Notes" in the Worksheet Name/Qualifier. 2. Notice that we've chosen a combined (computed) key for both tables-- Activity and Day for Activities table and Activity and Date for Notes table. This is because the combined values of each of those columns will form a unique key AppSheet can use to uniquely identify each row. In my Notes worksheet, notice that each each activity is listed with a day next to it. You'll see how this works in the next step. 3. We created a reference between column Activity in the Notes table to the Activities table. We did this by going to Advanced Editor > Data > Column Structure, selecting "Activity" from the Notes schema, and then changed its type to Ref. When we selected Ref, we needed to select a table we want to reference to. Now, when we add a note to an activity, the Activity combined with the Day (the computed key) will be a drop-down showing the values (the activity with the day next to it) from the Activity menu. You'll see in the dropdown we have distinguished between "Swim Practice: Monday" and "Swim Practice: Friday" so it's quick and easy to reference which activity on which day we want to write a note for-- since some activities happen more than once a week.
Data for this app
Education & Training