Shedules Settings Issue in Zoho Creator
I'm using Zoho Creator and want to add rules to trigger an email notification whenever one of these criteria is met:
1. It's 7th day after the date recorded in death_date field, which is Date-Time type field
1. It's 7th day after the date recorded in death_date field, which is Date-Time type field
2. The 40th day, respectively
3. And one year past after that date
I want the system to send reminders in form of email notification 2 days before those specified dates. I've created some schedules (see screenshot):
But the Form and Field fields are inactive, so I can't edit them.
And here is my script:
Which, as you can see, supposed to send e-mail containing information about the specific person 4 days after the day of his death.
But it doesn't work. Also, I can't find any information about using "Execute now" button. When you press it a modal window pops out requesting input arguments:
And here is my script:
sendmail
[
from:zoho.adminuserid
to:"sarkisyan.hayk@gmail.com","requiem.f.s@gmail.com"
subject:"7 дней " + input.FIO
message:"Покойник: " + input.FIO + ", " + input.CnundTaretiv + " года рождения.<div>Скончался: " + input.death_date + "<br>Контактное лицо 1: " + input.KontLico + " Телефон: " + input.Tel + "<br><div>Контактное лицо 2: " + input.KontLico1 + " " + input.Tel1 + "</div></div>"
content type:HTML
]
But it doesn't work. Also, I can't find any information about using "Execute now" button. When you press it a modal window pops out requesting input arguments:
I need to fill-in the ID filed, which stores data in this format XXX-XX-XX, but if you try to insert some of existing values form records of form it will never work. Though, it works if you pass nothing, in that case I get the same e-mail all the time, with the details from same record.
And it works if you pass random numeric value like "111", and I get email containing "null" as a result of evaluating deluge expressions.
And it works if you pass random numeric value like "111", and I get email containing "null" as a result of evaluating deluge expressions.