Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Cell value as Email subject

Topic Labels: Automations
1551 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Viky88
4 - Data Explorer
4 - Data Explorer

Hi there!

I have made a regular airtable automation to send an e-mail when certain conditions are met. I was wondering, is there a way to have a value (not a list of values) of a certain cell in a certain row as an e-mail subject?

To put it more directly, when status of an order (field order status) is "finished", an e-mail is sent where the name of the client (field client) from the same record is a part of the e-mail subject.

Any help is very much appreciated!

10 Replies 10
ScottWorld
18 - Pluto
18 - Pluto

Yes, that’s what automations are designed to do. Just click on the blue plus sign and choose the field from the trigger step.

if you need more power & customizability from your email automations, that’s where you would turn to an external automation tool like Make's advanced automations & integrations.

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

abhibavishi
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes, you can do this by using the Find block in the automation module, so that it triggers the automation only a single record: 

Screenshot 2023-08-14 at 5.59.27 PM.png

 

ScottWorld
18 - Pluto
18 - Pluto

No, that is unnecessary in what he is trying to do. 

laurenCTCL
6 - Interface Innovator
6 - Interface Innovator

I'm not having success using a field value in the subject line. I have a free text field for the user to enter their subject. I can populate the subject field in the automation with that field, but when I generate a preview, I consistently get a message "The "Subject" input is empty."

 

I would like the user to be able to generate their own subject, not go in and populate it as a static text item in an automation.

Screenshot 2025-02-11 at 2.41.57 PM.pngScreenshot 2025-02-11 at 2.42.41 PM.png

ScottWorld
18 - Pluto
18 - Pluto

You're only getting an error in the preview of the automation. That means that you haven't chosen a test record that has a subject typed in. You'll need to go back to your trigger and choose a test record that has a subject typed in. Then, you can test your action step.

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

thanks, that did the trick!

laurenCTCL
6 - Interface Innovator
6 - Interface Innovator

I wanted to follow up- there is something funky here. I'll run a preview, it will look good, then click the button to trigger the automation and it will give the "no subject" error, even though the test record and the field have a subject in the subject line. If I run a test from the automation screen, I get it fine, but if we click the button, it fails iwth the no subject error. It's like it's getting wiped out somehow. 

Screenshot 2025-02-13 at 12.56.19 PM.png

Screenshot above is me successfully receiving the email when clicking "Test automation."

Screenshot 2025-02-13 at 12.52.12 PM.png

Screenshot above shows subject.

Then when we try to run it from the interface, we get the "no subject" error again.

Screenshot 2025-02-13 at 12.59.52 PM.png

ScottWorld
18 - Pluto
18 - Pluto

Your screenshot above shows Subject #3, but your screenshot from yesterday showed Subject #1. Are you sure that your automation is pointing to the proper field?

- ScottWorld, Expert Airtable Consultant

laurenCTCL
6 - Interface Innovator
6 - Interface Innovator

Yup, diff automations. Here's what I just did: 

Successful preview

successful preview.png

 Successful test from automation screen

successful test from automation.png

Failed run from interface

failed run.png

The subject magically disappearing has happened enough times that I'm fairly certain I'm not screwing it up, but could be, for sure!