Good morning friends,
I have two tables: ticket and users.
The table users has columns [code], [user_name] and [user_email].
In the table ticket I have [users] column and [email] column, both of type enumlist.
When I select users in the ticket table, in the column [Email] I find the emails of users to send notification, thanks to the formula:
SELECT (users [user_email], CONTAINS ([_ THISROW]. [Users], [code])).
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |