However, most people using Airtable don’t know JavaScript and don’t want to learn JavaScript. Unfortunately, there are currently only 3 ways to automate the deletion of records:ġ. This is much needed in the product!īe sure to send this as a feature suggestion to, since Airtable employees don’t read our feedback here. Given how many people are experiencing this, I suspect it's related to something that they have changed.I totally agree with this suggestion 100%. I tested this on other automations that were built the same way that used to work and were also now failing.
Airtable automation formula free#
I am an expert Airtable consultant with tons of expertise in working with attachments, so If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you create this, please feel free to contact me through my website: Airtable consulting - ScottWorld. There are also many Make experts hanging out there who can answer other Make questions. There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses. If this is the problem, I would just use Make to handle your automation, because you can use their Sleep Tool to pause your automation for up to 5 minutes before continuing. If it works, then your automation is probably firing too quickly after the form is submitted, because Airtable needs a significant amount of time to finish uploading attachments. However, assuming that your automation is setup properly, did you run a test of the automation on an existing record that already exists in your database to see if it works? (Not a test by submitting a form, but a test on an existing record that already exists.) You didn’t provide any screenshots of how your automation is setup in regards to attachments, so I can’t tell you whether your automation is properly setup or not. Given how many people are experiencing this, I suspect it's related to something that they have changed. This is what the attachment selection looks like: I changed the attachment to actually select from the "update record" step, where it pulls the newly submitted document from the record.
Airtable automation formula update#
What I did was change the automation to go like this.I would update the record with the expense report document and then send the email. The send email task would fail and I got an error "An attachment URL is disallowed". The attachment was taken from the step "when a form is submitted", where they would upload a document "expense report":Īgain, that was working for a long time until it just stopped working recently.
This is how the original automation looked: I figured out the problem with my automations.I hope this helps someone out there! Just as a note, this was working for us for the past year and only started failing sometime over the past few weeks. I came across this community post along the way but it doesn't seem to answer the question here. The URL room is airtable-attachment-uploads-production.s3.Īny insight into the source of the problem/the solution would be great. This is the URL of the attachment uploaded in the failed attempt. This is the URL (incomplete) of an attachment when it was working on June 8. What I do notice is a change in the URL of the attachment. Nothing has changed to the automation or the file format. Steps 1 and 2 run just 's step 3 that throws the "An attachment URL is disallowed" message. Send an email to Y email address with Z attachment (from X form submission). Find record (where record ID matches record ID)ģ. When X form is submitted (including Z attachment)Ģ. I get a message: " An attachment url is disallowed". This automation hasn't run for a few weeks (since June and no changes were made but it's no longer working. I've seen some posts regarding this same issue, but no recent workable solutions so I'm posting again.
0 kommentar(er)
