I have a set of events held in a table that I need people to be able to respond to with their availability. In the past I’ve used doodle to send out a poll, but I’m now wondering if it’s possible to do this within Airtable, while providing a good user experience.
What I’d like to do is turn the events into a list with check boxes that participants can simply check. Anyone seen anything similar that may help?
…or am I better off looking at a Zapier integration?
Maybe it’s just because I’m tired, but I can’t think of a way to pull this off natively within Airtable. Even using Zapier won’t get you very far. If I understand you correctly, what you’re essentially trying to do is turn event records in one table into checkbox fields in another table, with that second table being filled out by your staff via a form to indicate their availability for those events. Zapier (and Integromat) can do a lot of things, but I don’t think that creating fields is one of them. I haven’t tried using the Airtable API yet, but I’m not even sure it can be done at that level.
In lieu of creating fields on the fly, you could set something up where the form has checkboxes for events, but those checkbox states end up converting into record links in Airtable between the event records and the staff. I’ve got a very very very rough idea of how you might be able to use a combination of Jotform and Zapier to pull this off, though it’s definitely gonna take a while to set up, and it might require On2Air: Forms (a product by @openside) to make it all work.