Hi Zoho,
I have a scheduled task, that runs through a form's data and adds entry IDs to a list (
SentMsgs).
Than, I'd like to send a report to the admin, showing only the entries that their IDs were added to the SentMsgs list.
I have scripted:
sendmail
[
from:zoho.adminuserid
to:zoho.adminuserid
subject:"Monday emails report"
message:"Hi Self, <br><br> Monday emails report attached.<br><br> Enjoy!"
content type:HTML
attachments :view:Flags_n_Alerts_Report[SentMsgs.contains(ID)] as PDF
]
But when I try to save I get an error saying ID variable is not defined (although I've picked him from the variable list on the script builder).
When I tried
attachments :view:Flags_n_Alerts_Report[ID = SentMsgs] as PDF -> I didn't get an error, but the report was not filtered at all (got all the existing entries).
The
SentMsgs list itself is fine (populated using
SentMsgs.add(CrntMsg.ID); )
Please help?
Thanks
Ravid