How do I email the person who created a row when it is modified?

1

Hello!

I use Coda to get approvals from my boss. I’d love to automate it so that when rows have a status changed, an email is automatically sent to the person who created the row.

I have looked through this similar question Email Automation: Send to email address based on row change and maybe I’m just new this, but I’m really struggling to understand how I can do this…

Help please!

2

For sure!

I thought it would be easier to record a video then write it out at length with screenshots, etc

Your principles are:

  • Create a createdBy() column to track who created a row
  • draw out that persons email
  • Set a row-changed automation that watches a status column
  • Use the gmail/outlook pack OR native NOTIFY action as the THEN part of your automation to conditionally notify the creator of the row

Also, heres the link to the example doc in case you want to see it! → [Example Doc]

6 Likes
3

This is amazing! Thank you so much Scott! It worked!

1 Like
4

You got it! Happy to help!

5

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