I created a google form for volunteers to tell me if they are able to help with a certain activity. This list of volunteers will be listed in a google sheets file. Volunteers can state their availability for one or more activities on different timeslots and dates.
In app sheets I created an action list for an local event. There are over 100 actions in this list of which about 10 actions need volunteer participation.
I want to see in app sheets for those 10 actions, who will be joining as a volunteer.
How can I link these two tables?
It sounds you are looking for related table structure. Please check this article.. https://support.google.com/appsheet/answer/10106510?hl=en
Likely also relevant to the design you describe: Use data from Google Forms - AppSheet Help.
User | Count |
---|---|
34 | |
11 | |
3 | |
2 | |
2 |