webhook for RSVP for different events

[Shelly]

Hi!

I want to send invite for event and I want to track who RSVP. How do I build base or connection? I am thinking weebhook. So every member gets email with the specific webhook (record id), but where (in which table) do I put it?

These are my tables: Members/Events/Speakers

How can i send email to every member with a link (webhook), that when the member click on "i am going" button in email, I can see the list of all who clicked either "i am going" or "i am not going".

I already created webhook in make and I added it in AT and customeyed it with record ID.

https://hook.eu2.make.com...' & "?Record=" & RECORD_ID()

I put this field in Members table.

Then I create automation:

Trigger: if the date of event is 1 week before today - in table Events

1st action is find records - in table Members (so that i can send emails to them)

2nd action in send email with webhook. and here my problem accour. I can only select "list of "webhook") in the email, because webhook field is in the members table). so when the email is send, in the message there is a whole list of webhooks of every member.

So I am not doing it right.

Does someone have better idea how to solve this smoother?

Thanks!

[ScottWorld]

1. I demonstrate how to use Make’s custom webhooks within emails in this Airtable podcast episode.

I demonstrate it in the context of approving/denying a task, but you can easily change it to RSVP’ing yes/no for an event.

2. However, an even easier way than using webhooks is to use Fillout’s advanced forms for Airtable.

Fillout is 100% free and it gives you the ability to update Airtable records from a form. 

Fillout gives you a formula that you copy and paste into Airtable, and the formula results in a unique form URL for each record.

You would then email each person their own unique form URL, and when they click on that link, they’re taken to a form which automatically updates their Airtable record — so they can choose the value for the RSVP field.

Hope this helps!

— ScottWorld, Expert Airtable Consultant 

[TheTimeSavingCo]

Hmm, try using a repeating group?  That way you can send one email per found Members record: https://support.airtable.com/docs/repeating-groups-of-automation-actions

[Shelly]

Thanks @ScottWorld for your reply. I saw your video about webhooks and done the same thing for another project and worked great. I build it for our company - employees have special link for the forms (becuase there is only 20 of us), when they click on the link the form is prefilled with his name and ID. When the form is submitted, my boss gets email for approve/deny the holiday request. When he click "approve" field in AT is updated, it automatically creates PDF and employee receive email with this pdf.

This all works great, if you have small number or users. Because I manually send this link to all our employees.

Now I want to send email with webhook to all my contacts when I create new event.

Basically what I want for the workflow: I want to create new event in a table Events. When I click "send invite" I want to send invite to all contacts, which are in the table "Members". In this email I want to have two webhook for "going" or "not going". When member click to "going" i want to update Members or Events table (for example in the table Events I want to update linked field "members") so that I can see which member clicked "going" to a specific event.

Is that possible, and can be done simple? 🙂

I will also look for the Filout forms.