Combining cells for repeated content/values

[Viky88]

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!

[ScottWorld]

Show how your automation is setup.