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?
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?
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |