Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 09, 2024 04:02 PM
Hello,
I am looking for some help on an automation I am trying to run. I am trying to use a make.com webhook with airtable so that when a new record shows up in airtable it sends the webhook to make.com. I have the script that I am using and the connection and everything works but the webhook does not send the correct bundle of information. It sends the record ID and then just generic information like 'header 'recipient', etc. I am a school teacher and not a coder so I have been trying to get Chatgpt to help me with the script and I feel I am really close but don't know the scripting language enough to diagnose the problem. Any help would be appreciated.
Aug 11, 2024 10:39 AM
Thank you for responding. I don't know exactly as to what you are describing, but I am trying some of those things. I know in your screenshot that my bundle did not include the recordID: recSjS...........that was missing. I am still having trouble getting the webhook to come from airtable and start my automation. I I have
1. Webhook
2. Webhook Response
3. Google Docs
4. The rest of my automation........
5. I think my automation is going to be pretty close to done, but I j ust can't get it to work correctly.
Thank you so much.
Mike
Aug 11, 2024 10:40 AM
The script i am using now, does bring over all of the fields. So manually i can get those fields over there when i trigger my automation manually, but I still just can't get the webhook to work. Thank you.
Mike
Aug 11, 2024 10:41 AM
Thank you, I got a script from the internet and believe it works for the most part.
Aug 11, 2024 10:43 AM
I did not know that. I was copy and pasting my new records from previous records. That was not the underlying problem, but that is good to know. So when you have a form of 30 fields, what methods do you use to not have to fill in the form over and over again to test?
Aug 11, 2024 10:43 AM
Yes, no data, and the recrodID did not show up?
Aug 11, 2024 03:58 PM
If you could provide a read-only invite link to a duplicated copy of your base with some example data I could take a look at this for you! https://support.airtable.com/docs/adding-a-base-collaborator#adding-a-base-collaborator-in-airtable
Aug 12, 2024 05:07 AM
Hello @Schmidt127
Note → @ScottWorld & @TheTimeSavingCo have already explained most of the things about how to send and handle those webhooks. So I don't want to repeat it. But just try to explain to you the nature of airtable automation.
Before you go to the part of the call make a webhook. These are things you need to know.
First of all, just understand your trigger point is to add a record as you mentioned and @ScottWorld confirmed about that in earlier responses. But for more information, there are multiple ways to add records 1) Manual 2) Via Form submission 3) Via API 4) Import data.
1) Manual → When you add a record as a manual(in Airtable) by default all the fields are blank at the starting point just recId(rec****) is there to access in automation.
2) Via Form → When an Airtable form is submitted it also creates a record on a specific table and it comes with all the data(fields) which is set on the form.
3) Via API → It is the same as form but instead of using the form you can use any third-party tool or directly send using their API Airtable Web API
4) Import → Just create multiple records based on your source of data.
Now the important thing is using any of the approaches by default whenever the record is created its have recId(rec****).
But,
Here is a thing you need to understand that about automation nature.
No matter which approach you've used when you set trigger automation when the record is added. Then automation is triggered instantly when the record is created. Now when you use the 1) method that time is record is created but all other visible fields do not have data(Maybe you're just filling it, But automation already triggered on add). So in this case you can't pass the other data fields because it is not there to pass alongside your hook.
But this same thing works with all other methods because there is data so you can pass it alongside your request.
If this is the case for you then use condition match when the record is entered to view the approach for trigger automation.
It's a bit long but I hope this helps.
👍