Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 23, 2024 09:01 PM
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 🙂
Solved! Go to Solution.
Apr 24, 2024 08:00 PM
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
Apr 24, 2024 03:02 AM
Is the attachment in another table in the same base? Could you provide screenshots of the relevant tables and fields?
Apr 24, 2024 04:23 AM - edited Apr 24, 2024 04:24 AM
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
Apr 24, 2024 04:26 PM
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)
Apr 24, 2024 08:00 PM
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
Apr 24, 2024 09:55 PM
That’s another good way of doing it as well!
Apr 24, 2024 10:31 PM
Both of these solutions worked - thank you both so much!