Use table cell entries as E-Mail receiver

Hello,

I am completely new to Coda and I try to achieve the following:

I have a table with a few rows:

Now, if the status changes, I want to sent an E-Mail to the E-Mail-Address cell of the row which has its Status changed. I created an Automation and addres a rule with a “When trigger” (as seen in the screenshot above).

And now I want to sent the mail to the value of E-Mail-Address of the changed row with the corresponding values of the Subject and Message columns. How can this be achieved . thisRow seems to be something different and I have no clue how to reference the currently modified row and its cells.

Hi Jan,

You are looking for Step 1 result, which is a reference to the changed row that triggered the automation

Hope this helps,

Pablo

3 Likes

Hello Pablo,

yes, that helped a lot. Many thanks!
Jan

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.