Use automation to copy attachment to new record

Hi all, I’m loving the new Automations in Airtable, but getting stuck on what I think should be a pretty simple thing…

I have a table that functions as an inbox for messages and attachments coming in via a Zapier integration from an email inbox.

And I want to then use Automations to copy these incoming records to various tables where they’ll be processed - I have a growing variety of incoming message types so want to split out the handling of each type to a dedicated table.

I can easily create new records and populate with much of the relevant data, but I cannot move an attachment(s) across to the new record in the second table.

What’s the easiest way to achieve that?

Thanks!

Use Zapier to create the new record if it has an attachment. Zapier will copy the attachment to the new record, but built in automation won’t for some reason.

Thanks for suggestion - I’ve found Zapier as it has its own issues with multiple attachments - -it ends up wrapping them into a zip archive which I want to avoid. Cheers

Try creating a formula that pulls out the attachment URL from the attachment field:

RIGHT(LEFT({Attachment Field}, LEN({Attachment Field}) - 1), LEN(LEFT({Attachment Field}, LEN({Attachment Field}) - 1)) - SEARCH(“https://”, {Attachment Field}) + 1)

Then reference that Formula Field in your automation to create a new attachment in another table.

Hope that helps!

Can you show an example or elaborate further? I tried recreating this as a formula field referencing an attachment field and it did not work.

Actually, the solution is even easier than that.

Simply insert the attachment field’s URL from within the automation itself. See screenshot below:

1 Like

yes that seems to be a recent update to Airtable automations - it can now handle attachments natively!

1 Like

You need to watch this method. It will REPLACE existing attachments, not ADD to the attachments.

2 Likes

Ooh, that’s a really good caveat to know about.

For ADDING attachments, I can’t recommend Integromat highly enough. It’s my absolute favorite automation platform, and it is simply amazing, It has tons of flexibility and features, and it’s super inexpensive, too. (It’s about a zillion times better than Zapier, which is also significantly more advanced than Airtable’s automations.)

2 Likes

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.