Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Use automation to copy attachment to new record

Topic Labels: Automations
Solved
Jump to Solution
3462 8
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Solution

Accepted Solutions

Actually, the solution is even easier than that.

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

Screen Shot 2020-09-22 at 6.07.04 PM

See Solution in Thread

8 Replies 8

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:

Screen Shot 2020-09-22 at 6.07.04 PM

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

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

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.)