Hi all,
I have created a scheduled task to send reminder emails to customers for payment status = "pending"
However I can't seem to dynamically allocate the names properly in the email. Detailed explanation below:
I have attached 2 pictures for reference:
- database.png & scheduledWorkFlowProperties.png
Current Situation
Emails are sending out but the customer names are wrong.
Problem statement:
Currently the emails are sending out for the name "TAN HENG HUAT" only.
Desired Outcome
Send a reminder Email to customer 3 minutes after record has been added. Please refer to dataBase.png
At 2045: Send email - Dear TAN HENG HUAT, xxxxx
At 2046: Send email - Dear LIM SHONG BOON, xxxxx
At 2047: Send email - Dear HENG GANG ZHENG JASMON, xxxxx
The settings for scheduled workflow are screenshot (scheduledWorkFlowProperties.png)
My code are as follows:
- getName = MasterForm[FormName != ""].FormName;
- subject = "test reminder";
- mainMessage = "Dear " + getName;
- sendmail
- [
- from :zoho.adminuserid
- to :"testingMail@hotmail.com"
- subject :subject
- message :mainMessage
- ]