This thread is only to ask if anyone can confirm if this is possible… and if it is… then WOOHOO, I will sign up for a Pro account immediately and abandon my attempts at this in FileMakerPro!!!
Scenario: I run a youth program with about 85 teenagers enrolled. Throughout the year we offer trips, excursions, courses, events, competitions, etc. In preparation for each event, I need to know how many kids intent to participate so I can plan for meals, resources, transportation, etc.
Currently I am doing this via Google Forms. I create one form for each event, and ask the kids to fill it in if they want to participate. But that means that every single time they have to enter their first name, last name, email address, phone number, etc. Which is crazy, since I have all that info already. But by doing it this way, the Google Form fills out a Google Sheet, which becomes my roster of attendees for planning, attendance, contact roster, etc.
Two days ago a friend introduced me to AirTable… and I am hopeful this will be a superior platform for this project.
I want to create a mechanism where the kids can log onto a personal page and check which event(s) they wish to participate in. Each person would have their own page, pre-populated with their name, phone number, etc. The only thing they would be doing is checking yes/no to the listed events.
This way I can have one database with all their contact information in one place, and one place to manage the list of events. I realize I would likely have to configure one page for each child, which is fine. It would be a simple matter of copy/paste/tweak I imagine. But this would eliminate the need for each kid to fill out the form every time, they could simply log onto their page and review the newest events and opt into them.
The two big requirements I’m seeking confirmation that are possible is 1) could I create a page for each kid that would have a unique password to access it, and 2) could I create that page with that specific child’s info and list of events they could select Yes/No for.
If those are possible, then I am highly confident all the other needs can also be done (rosters, etc.)
I’m not seeking the solution here by any means… simply seeking if this scenario is possible in Air Table… and if so, then I shall immediately begin learning AT!
Thanks in advance to anyone who can chime in and guide me as to whether or not this is doable.
(sidenote: it is totally possible in FileMakerPro, but FMP is overkill for my needs… It’s like taking a tank to 7-11 to buy milk in this case!)