Apr 24, 2023 01:10 PM - edited Apr 24, 2023 04:20 PM
Edit:
Airtable response:
Our engineering team has successfully deployed a fix for this issue (which arose from a recent update to our code) and any automations referencing an attachment should now run as expected without error.
It's working again. Thank you all.
---
Hello.
I've been using the Send Email action in automations for more than a year. Always worked great. In the Send Email action, in the Attachments section (Bottom) I selected the column that contained the file, and that file was attached in the email.
3 days ago, my automation worked fine. But today, when the automation triggered, there was a problem (An attachment url is disallowed):
I already turned off and on the automation, changed the trigger, changed pdf file for jpg, and always the same error.
I tried the automation with records that already triggered a few days ago and worked fine (My trigger is a Single select column, so, to trigger it again, I deleted the value in the single select field, and select it again). Same problem.
I already wrote to Airtable Support, but I wanted to write here too, because it is a very important feature in my workflow, and maybe one of you can help me find a solution or a workaround.
Thank you very much for your help.
Solved! Go to Solution.
Jun 28, 2023 09:41 AM
This is still an issue with us, and the automations are CRITICAL to our business operations, as they are tied to reporting requirements for our clients.
I need this fixed yesterday - absolutely ridiculous that this is still an issue. This is basic functionality.
Does anyone have any suggestions?
Jun 29, 2023 05:32 AM
Jun 29, 2023 05:51 AM
Same problem
Support cannot be reached by email as email support has been deprecated for "plus plan" users...
And their chat is powered by a bot... I can't even find how to submit a ticket....
This is not acceptable for paid users to have such a bad / non existent support
Jun 29, 2023 06:34 AM
This error has now started to affect our important automations (again). I have reached out to enterprise support and will update here when I hear back.
Jun 29, 2023 08:05 AM
I have excatly the same problem, today June 29th
Jun 29, 2023 08:09 AM
The problem is not solve. It is impossible to send an automation with send an email with attchment made from a form
Jun 29, 2023 11:07 AM
Here is the response from enterprise support with a workaround for this behavior. I am not sure why this issue has popped up after months of it not being a problem.
Based on the error message you're seeing, it's likely the automation is firing before the attachment has been fully imported into our storage. Once a file has been fully uploaded into our storage, the attachment will then feature its unique Airtable URL instead.
We're working on improvements to this behavior, but in the meantime, there are a couple of ways to delay the automation (depending on your particular use case) to give the attachment time to fully process would be:
IF((LEN(Attachments)-LEN(SUBSTITUTE(Attachments,",",""))+1)*15=(LEN(Attachments)-LEN(SUBSTITUTE(Attachments,"dl.airtable.com",""))),"RUN")
From here, you'll add conditions to your trigger step saying "When Attachment formula contains 'RUN' " (like this)
IF(NOT(Attachments), "NO ATTACHMENT", IF((LEN(Attachments)-LEN(SUBSTITUTE(Attachments,",",""))+1)*15=(LEN(Attachments)-LEN(SUBSTITUTE(Attachments,"dl.airtable.com",""))),"RUN"))
Now, the automation should wait until the attachment is processed before being triggered.
Jun 29, 2023 12:02 PM
that is super complicate, do you have a simple solution?
Jun 29, 2023 12:45 PM - edited Jun 29, 2023 12:52 PM
Here is another solution I can think of that would be simpler.
Create a formula field called "Send Email" with this formula:
IF(CREATED_TIME()<(DATEADD(NOW(),-20,"seconds")),"Yes","No")
Change your automation trigger from 'when a form is submitted' to 'when a record matches conditions'.
Make the trigger condition 'when Send Email contains Yes'.
Although this would appear to delay the automation by 20 seconds, in reality it will delay the automation by up to 5 minutes, since "NOW()" in Airtable only updates every 5 min or so. If the email going out 5 minutes later is better than the automation failing, this may work for you.
Jun 30, 2023 09:23 AM
Same issue on many business critical automations 😭