I have a problem with my base. On my base, I have 3 differents tables, bénévole = volunteer, événement = events and inscription événements = events registration.
On the first, I have the list of the volunteer. For each volunters, I want that they have the first event that they have participated in Evénement A, the second in Evenement B… The Events are from the second table.
On the second table, I have the list of the events with all the information about the event.
On the third table, I have two view, the Grid one and the form one. With the form, the volunteer could registrate to the event (column Evenement). They can choose multiple Events. On the Grid view, I have the detail of the volunteers registrations.
I want that when the volunteer signs up on events, the different events will be add to his record on the “Bénévoles” table. As the volunteer can sign up to multiple events, I don’t know how to do it.
I thought to use Zapier but I don’t really how ?
Someone could help me please ?
Tell me if you want more informations.
Thanks in advance.