My main table contains rows from different users who input data through the app and all the data accumulates in one table. I want to email scheduled reports to those users BUT only for their own data. For example see below:
[User Email] [Timestamp] [Member ID] [Name]
123@noone.com 9/23/2020 23:29:45 1002 Name1
456@noone.com 9/23/2020 23:49:31 1002 Name2
456@noone.com 9/23/2020 23:53:54 1003 Name3
I want to send a scheduled email report to 123@noone.com for row # 1 only
I want to send a scheduled email report to 456@noone.com for rows # 2 and 3 only
How do I do that? Please help.
Thanks.
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |