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

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?

0 3 414
3 REPLIES 3

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].

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

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

Top Labels in this Space