Email alert based on field

[inescastelhano]

Hi all,

I want to create an alert based on a condition, where the recipients should be a field.

Example:

Event     owner                                        status

1            ines.castelhano@mail.com     approved

2            mary.jane@mail.com               not approved

My condition would be 'if event not approved, send email to owner's email'.

However, when hardcoding the email the alert works, when using the field 'owner' as recipient, doesn't work.

Does anybody have an idea on how to solve this?

Thanks in advance.

Regards,

Ines

[danielact · Accepted solution]

I believe the email doesn't cycle through fields. You can try setting up a variable which concatenates the email addresses in the format used for multiple emails (I don't use alerts much, so I don't remember offhand how to separate them).

[krishnacbe]

Hope the Owner field has multiple values.

You need to convert them into ; separated values. May be like below.

replace(GetFieldSelections(Owner), ',',';')

[inescastelhano]

It worked perfectly with a cycle and a variable, concatenating the emails in the variables' value.

Thanks!

Ines