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. 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. When we selected Ref, we needed to select a table we want to reference to. We did this by going to Advanced Editor > Data > Column Structure, selecting "Activity" from the Notes schema, and then changed its type to Ref. We created a reference between column Activity in the Notes table to the Activities table. It’s a to-do list app and it’s technically for that use case. You'll see how this works in the next step.ģ. Daily and all-round planner TickTick Price: Free / 27.99 per year TickTick is an outstanding app for day-to-day use. In my Notes worksheet, notice that each activity is listed with a day next to it. This is because the combined values of each of those columns will form a unique key AppSheet can use to uniquely identify each row. 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. To specify the Notes table, we made sure to include "Notes" in the Worksheet Name/Qualifier.Ģ. AppSheet always defaults to using the first worksheet, so the first table is fine as is. We added both tables via Advanced Editor > Data > Tables > +Table. We created two worksheets within one workbook: a table for Activities and a table for Notes. We 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.ġ. Clicking "New" allows you to add a new note, with the ability to choose which activity and which day, specify the exact date for the note, and then add your comments. If you click into an activity, you'll see next to "Notes" a "View" and a "New" button. Clicking "View" allows you to see helpful notes instructing the user about special circumstances for that day's activity. That number refers to how many notes there are for that activity. When you click into any activity, you'll see a "View" button with a number next to it. View notes associated with activities on specific dates. You'll be able to name the activity, choose the day, the time, and add an image. If you take on a new activity and want to add it to the schedule, just click "New". The activities view groups the activities by day so it's easy to quickly see what is happening when. You can do the following with the Extracurricular Schedule: Explore the interactive sample app on this page then create a activity schedule app of your own.Ī customizable app for keeping track of events, share and collaborate the schedule and details of your choice.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |