Skip to main content
Solved

404 Not Found Error when trying to update AirTable record from Make.com automation

  • November 8, 2025
  • 8 replies
  • 39 views
C
Forum|alt.badge.img+2

I create a Make.com automation that sends out a transactional email to the customer when a new record is created in my enrollments table.  The last step in the automation is to update the Enrollment record so show that the Confirmation Email was sent out by updating the record with today’s date.

It’s a rather basic setup, but every time I test it out I am getting a “404 Not Found” error when Make tries to update the record.

I have checked the Input / Output in the error, but I’m not finding anything useful.  The OAuth connection is working fine to pull the records, and the Base / Table / Field names are all pulled from the dropdowns.  I also checked the Base ID, Table ID, and Field ID from the output bundle, and they are correct.

Airtable Update node

 

404 Error 

 

Input Bundle 

 

Output Bundle 

 

Airtable Field

 

Best answer by ScottWorld

You are trying to use the Enrollment ID as the record to update. That is not the record ID — you need to use the official Airtable Record ID as the record to update.

Hope this helps! If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

8 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9787 replies
  • Answer
  • November 8, 2025

You are trying to use the Enrollment ID as the record to update. That is not the record ID — you need to use the official Airtable Record ID as the record to update.

Hope this helps! If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

C
Forum|alt.badge.img+2

That was an easy fix for that part ​@ScottWorld - thanks!  The 404 error is now gone.  I did get a new issue - though hopefully it’s easy.  Even though I have the date field setup in Make.com as “{{formatDate(now; "MM-DD-YYYY")}}” - it went into Airtable as DD-MM-YYYY for some reason.

 

 


What’s weird is even in the Input bundle, it’s flipped now

C
Forum|alt.badge.img+2

For some reason the date fix isn’t as easy as I thought, haha.  I tried deleting and re-setting up the AirTable update node - and it is still going in as DD-MM-YYYY instead of MM-DD-YYYY as I specified in the format date function.   I’m a bit stumped since everything looks right to me in the node setup - so I’m not sure what to even try to fix it.  What’s also bizarre is that before - when I was getting the 404 error - the Input Bundle was showing the date correctly.  Now that I fixed the ID, the Input Bundle shows the date in the wrong format.

 


 

 

 

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9787 replies
  • November 8, 2025

I’m not sure why, but I would just remove the date formatting altogether when sending the date to Airtable. Just put in that “now” token all on its own.

- ScottWorld, Expert Airtable Consultant 

C
Forum|alt.badge.img+2

Troubleshooting, I tried a few options for other date formats:



Of the formats above, the only ones that went in correctly were “ID Date” and “Attend Date”
 


I can set all of my dates in Make to YYYY-MM-DD if need be, but seems like quite the odd issue….​​

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9787 replies
  • November 8, 2025

Did you see my message above? As I mentioned above, you don’t need to pre-format your dates in Make before sending them to Airtable. Just send “now” to Airtable, which will send it to Airtable in the properly-accepted date formatting standard. (If even that doesn’t work, then it’s possible that you’ve set your date formatting incorrectly in Airtable.)

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

C
Forum|alt.badge.img+2

I’m not sure why, but I would just remove the date formatting altogether when sending the date to Airtable. Just put in that “now” token all on its own.

- ScottWorld, Expert Airtable Consultant 

For some reason I wasn’t seeing this response - but that worked perfect.  Much simpler. Thank you for your help!!

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9787 replies
  • November 8, 2025

You’re welcome! Glad I could help! :) And happy to see you using Make, one of my favorite tools! 

- ScottWorld, Expert Airtable Consultant 


Terms & ConditionsAccessibility statement