Hello,
I am new to using Appsheet. I am trying to create an app so that kids can easily figure out their camp duties. I would appreciate some general guidance on how I can get started. Perhaps there is a similar app or template that already exists?
I have shown some sample data below (greatly simplified).
| Day | Duty | Name |
|---|---|---|
| Monday | Head cook | Peter |
| Monday | Asst. Cook | Zoey, Austin |
| Monday | Fire Builder | Sam |
| Monday | Fire starter | Marilyn |
| Tuesday | Head cook | Zoey |
| Tuesday | Asst. Cook | Sam, Peter |
| Tuesday | Fire Builder | Marilyn |
| Tuesday | Fire starter | Peter |
| Wed | … |
The app would allow a kid to make the following selections using a drop-down menu.
Q1) Select Day >> drop-down selection >> Monday
Q2) Select Duty >> drop-down selection >> Asst Cook
Click a button like “Next”
The result would then be displayed based on the combination matched in the table row. So in this case response would be as follows:
“Monday Asst Cook(s): Zoey, Austin”
Alternatively:
Q1) Select Day >> drop-down selection >> Monday
Q2) Select Name >> drop-down selection >> Marlyn
Click a button like “Next”
The result would then be displayed based on the combination matched in the table row. So in this case response would be as follows:
“Marlyn, your duty on Monday is Fire starter”
Thank you in advance!
Munir