Nov 01, 2021 08:33 AM
I’m looking to create an approval email that contains an html button that when clicked, updates an approval status field for the record that triggered the email. Basically a way for approvers to approve from an email. Is this possible with webhooks or otherwise? Thanks
Edit: Not sure if I’m on the right track yet but I created a webhook automation step and sent a test POST request from Postman to the webhook URL which only worked after manually adding the content-type application/x-www-form-urlencoded header to the request. I’m guessing there’s no way to add this header to a URL or no?
Nov 01, 2021 08:56 AM
Nov 01, 2021 09:03 AM
Thanks for responding! Ah it sounds like JS is needed to send a webhook and running JS from an email would be a security nightmare. Also that it is possible using a custom proxy app that will then send the webhook based on something like URL query parameters received in an HTTP request. Is that right? Thanks!
Nov 01, 2021 09:14 AM
You can even create a custom response webpage as well.
You would just need to make sure each email has a unique URL to represent which Airtable record you want to update.
If you have a budget for your project and you need help setting this up from an expert Airtable/Integromat consultant, please feel free to contact me through my website:
Nov 01, 2021 09:25 AM
Thanks, Scott! Am I understanding the process correctly here?
So in this example, Integromat acts as the “custom proxy app” that I mentioned earlier?
Nov 01, 2021 09:28 AM
Correct - there is a way to do it but it is complex and largely brittle because of SMTP itself.
Nov 01, 2021 09:29 AM
Right, Integromat is your “custom proxy app”, but it will actually handle everything for you.
So you’ve got your step #1 and step #2 correct, but step #3 and step #4 are handled by Integromat. Integromat will receive the webhook information and then it will make the updates in Airtable on your behalf.
Nov 01, 2021 09:41 AM
Ah I see. Interesting to learn about. Thank you very much!
Nov 01, 2021 09:41 AM
Thank you for clarifying. That makes sense. Providing Integromat read/write access to our data would most likely require another IT security review but perhaps the webhook approach does not… I’ll have to explore this a bit more. Appreciate all the help!
Nov 01, 2021 09:45 AM
To clarify, you COULD send the data back to Airtable in the form of a URL webhook call that Airtable then processes with its own automation.
So you COULD keep your original steps 3 and 4.
I was just trying to keep things simpler for you, without so much back & forth between the apps.
Mar 21, 2022 03:30 PM
Often, you need to use a high-quality proxy server to update urls. A proxy server can be used not only as a means of accessing blocked websites, but can also be used to restrict access to websites for individuals using the network. Businesses can use proxy servers to prevent employees from accessing websites that could damage the company’s network or reduce overall productivity. That’s why I decided to buy a proxy server. This has significantly improved the quality of work.