Workflow - generate email

[tcanelli]

We want to create a workflow that will email specific information to people as they check in. The workflow would be triggered on the “check in” but we only want to email that person’s information to them. These individuals do not login to the app so I can’t use “username” or useremail.

Is there an expression that would pull the person’s email from their record to email them just their info?

[Steve]

So long as you have the email address in an app-available table, you can use it.

[tcanelli]

We do have that in the sheet. I’m just not sure what the expression would be or how to set this up to do what I want. In the workflow for email, in the email to field do I just select the email column? Or does it need a _this or _thisrow command??

[Steve]

tcanelli:

In the workflow for email, in the email to field do I just select the email column?

If the email column is in the row that triggered the workflow, yes, just reference that column (e.g., [email]). You shouldn’t need _THIS or _THISROW.