Aug 13, 2023 12:16 PM
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!
Aug 14, 2023 05:22 AM
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.
Aug 14, 2023 05:34 AM
Yes, you can do this by using the Find block in the automation module, so that it triggers the automation only a single record:
Aug 14, 2023 05:36 AM
No, that is unnecessary in what he is trying to do.