Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

User updating one field of their records

373 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there,

Simplified explained, I have a newsletter.

The email addresses and other user details are saved in Airtable. The content of the newsletter is generated with Airtable automations. I want to send a personalised email to the users asking them if they want to unsubscribe.

Rather than them needing to reply me to me via email I would like to add a button to that email if when clicked would update their status in the Airtable record to "unsubscribed".

Is this possible?

Thanks, Jakob

1 Reply 1

One of the easiest ways to do this would be with a webhook from Make. The webhook will give you a permanent URL that you can use. Be sure to create a formula in your table that gives everyone a customized version of that URL that includes their Airtable record ID. (for example, the final URL might look something like this: https://www.example.com/?rec=123456, which would be a formula like this in Airtable:

"https://www.example.com?pc=" & RECORD_ID()

Then, you can use the Airtable modules in Make to change their status, and you can give people a customized response in their web browser by using a webhook response in Make.