I would like to make multiple categories, and...

(Abdullah Noman) #1

I would like to make multiple categories, and assign an email address for each category when a certain condition is reached an email will be sent to that person.

is it possible?

(Aleksi Alkio) #2

If you have a table of categories with an email column, you could read the correct email address with LOOKUP. Read it likeā€¦ LOOKUP([_THISROW].[Category],TableName,Category,Email] or if you do it with the Ref field, you can use deref formula like [Category].[Email].

(Abdullah Noman) #3

meaning I can send an email with the content I want to each Category?

(Aleksi Alkio) #4

You want to send the category record itself and one column in that table contains the email address?