Mar 09, 2023 01:48 PM - edited Mar 09, 2023 01:51 PM
Hello everyone,
I want to allow a list of people (whose information are already stored in a table) to book different events in a Calendar they could access. The booking system would allow them to see all upcoming events, and register to the ones that we still have availabilities for (let's say 5 participants maximum per event for example).
I had access to the "No-Conflict Asset Reservations" template, and it seems promising, but it implies that the Assets will be available 24/7, whereas I would like to let people choose among a list of pre-defined slots.
All the registrants will be pre-existing records in my "People" tab. Ideally, I would like the process for them to be:
Is there anything I could work with ? Interfaces maybe ?
Thank you very much in advance !
Solved! Go to Solution.
Mar 17, 2023 07:45 AM
Hmm, if they're paying collaborators, yeah Interfaces would probably work great for this
If they're not paying...then a shared view with a form would probably be the way to go
If I were you I'd provide a shared view that shows all of the available events, and I'd have a button field in that view that would open a form. This form would have a text field where the user could input their email address and a linked field for the user to select from a list of available events
I'd also have an automation that would trigger when a form was submitted, and it would link the form submission to the correct person based on their email address
---
> After the event has passed, the system ticks a box saying "participated to Category A" event, or B or C according to event type.
For this, I'd create a formula field to check whether the date of the event has passed, and if it did it would output text like "Has passed" or something, which would in turn trigger an automation that would update stuff appropriately
Mar 17, 2023 07:45 AM
Hmm, if they're paying collaborators, yeah Interfaces would probably work great for this
If they're not paying...then a shared view with a form would probably be the way to go
If I were you I'd provide a shared view that shows all of the available events, and I'd have a button field in that view that would open a form. This form would have a text field where the user could input their email address and a linked field for the user to select from a list of available events
I'd also have an automation that would trigger when a form was submitted, and it would link the form submission to the correct person based on their email address
---
> After the event has passed, the system ticks a box saying "participated to Category A" event, or B or C according to event type.
For this, I'd create a formula field to check whether the date of the event has passed, and if it did it would output text like "Has passed" or something, which would in turn trigger an automation that would update stuff appropriately
Mar 20, 2023 11:24 AM
I'm looking for the same thing, basically. We currently manage event registration through Zoom, and we have a shared calendar view that shows upcoming events. When the user clicks on an event, there's a "Register" button that goes to the event registration page in Zoom. But what I'd like to do is just manage all registration in Airtable, and have that "Register" button go to an Airtable form where they just fill in their name, email, and one or two other fields, then submit. That submitted record should be automatically connected to the event on the calendar that they selected. This last bit is the tricky part that I can't figure out.
The other option (which I don't think is currently possible), would be to have a form with a built-in calendar field that lists the details of upcoming events, from which they could select. When I add a linked field that connects to our Events table on the form, it just lists the names of the events, with no option to view more details such as time or date.
Thanks in advance for any ideas!
May 15, 2023 09:22 AM
I guess that is the best way to do it without the users having paid account, thank you !