Scheduled workflow to email to each user out of the same workflow template.
I wish to send email to each user one by one, through the single schedule workflow (report).
I have table, this is is kinda of list of tasks. On my apps, users post various “report” and then users would view those.
Once the user view a certain report, then they explicitly change the status from “Unread” to “Read”.
This unread/read status is contained in the said table.
On the scheduled workflow, i wish to send mail to each users with attached template where it have a list of table for the “unread” report only and also only for that user who receive the email.
Is it possible to restrict the rows appearing report only to the ones which contains the email address for the addressed users? and each different report to be submitted to the each appropriate users, rather than showing full list of the table of contents out of whole table?
At the end, one user would receive email at the scheduled time with attachment, contains the list of the “unread reports”, and same for the other users, but each user would view the list to do with him/her.