Skip to main content
Solved

Automation - send email with attachment


Forum|alt.badge.img+4
  • New Participant
  • 3 replies

Hi everyone, I'm a beginner at airtable automation (so excuse the novice question) - I'm trying to figure out how to set up an automation to send an email with attachment when a new record is created. Same attachment will be going to all emails. 

More info: 

1. User fills out a form on website with email address. 
2. New record is created in Airtable table "Contacts" with the email address
3. I think this record then needs to be updated to include the attachment (unsure how to do this) so that it can be attached in the email automation

Any help would be greatly appreciated 🙂 

Best answer by TheTimeSavingCo

raffy wrote:

Yes, the attachment is in another table in the same base. The setup at the moment is pretty basic because I'm so new to this and am not sure what the best way is to set this up 😅 One table has just "email" which feeds in from a form on a website. The other table has just the attachment - screenshots attached. I think I need to somehow get the table with emails to update each time a new record is created, to link to the attachment (but am unsure how to do this)


Thanks!  In your email automation try adding a "Find Record" action to look for the record "Checklist" in "Attachment", this'll let you add it to your email in the Attachments field:

And I've set it up here so you can see how it's set up

View original
Did this topic help you find an answer to your question?

6 replies

TheTimeSavingCo
Forum|alt.badge.img+28

Is the attachment in another table in the same base?  Could you provide screenshots of the relevant tables and fields?


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8763 replies
  • April 24, 2024

@raffy 

In order to do this, you would need to setup a “global attachment field” in your base.

Unfortunately, Airtable doesn’t natively support “global fields”, so you will have to “hack” this yourself.

I give complete step-by-step directions on how to create an email with an attachment field from a global attachment field in this Airtable podcast episode.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • April 24, 2024
TheTimeSavingCo wrote:

Is the attachment in another table in the same base?  Could you provide screenshots of the relevant tables and fields?


Yes, the attachment is in another table in the same base. The setup at the moment is pretty basic because I'm so new to this and am not sure what the best way is to set this up 😅 One table has just "email" which feeds in from a form on a website. The other table has just the attachment - screenshots attached. I think I need to somehow get the table with emails to update each time a new record is created, to link to the attachment (but am unsure how to do this)


TheTimeSavingCo
Forum|alt.badge.img+28
raffy wrote:

Yes, the attachment is in another table in the same base. The setup at the moment is pretty basic because I'm so new to this and am not sure what the best way is to set this up 😅 One table has just "email" which feeds in from a form on a website. The other table has just the attachment - screenshots attached. I think I need to somehow get the table with emails to update each time a new record is created, to link to the attachment (but am unsure how to do this)


Thanks!  In your email automation try adding a "Find Record" action to look for the record "Checklist" in "Attachment", this'll let you add it to your email in the Attachments field:

And I've set it up here so you can see how it's set up


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8763 replies
  • April 25, 2024

That’s another good way of doing it as well!


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • April 25, 2024

Both of these solutions worked - thank you both so much! 


Reply