Sep 16, 2017 08:05 PM
Hello,
I’m trying to set up a volunteer management database including (among other things) a table for volunteers, and a table for events.
I have a form for new volunteers to add themselves to our list of volunteers… I’m trying to figure out how I can make a form that will allow existing volunteers (already in our volunteer table) to sign up for specific events / shifts. Is there a good way to do this?
Thank you!
Timothy
Feb 17, 2018 05:53 PM
Hi @Timothy_McCormick! I created something which kind of fits your question, but it is by no means perfect. I’ll try my best to describe what I did and how, in hopes that it helps!
I created an Conference Event database containing the following tables:
Table 2 Assigned Action Items contains a column which links to Table 1 Project Management Tasks. As new volunteers sign up, they can self-assign to various tasks.
Table 3 Event Agenda (your event sign up) contains a column which links to Table 4 Scheduling Grid (your event shift). As conference presenters (your volunteers) click the public share link to join the base, they can select their preferred presentation time on Table 4, then click the tab for Table 3 and fill in details of their presentation (title, duration, subject matter, name of presenter & organization) before selecting the column which links to their chosen time slot on Table 4.
Screenshots of Table 3 (your event sign up) & Table 4 (your event shift)
Hope this helps!
~ PJ
Apr 10, 2018 01:03 PM
Hi @Pamela_John
Thank you for sharing your work. I am trying to do something similar but am having trouble picturing the tables that weren’t added as a screenshot. Would you mind sharing the other ones too?
Thank you for your time!