Form Schedule Script Issue
I have set up a Form Scheule with the following script.
x = Daily_Test_Weight[Date_field == zoho.currentdate].count();
y = Daily_Test_Weight[Location == "DFW"].count();
if((x != 1) && (y != 1))
{
sendmail
[
from:zoho.loginuserid
subject:"Daily Test Weight DUE!"
message:"Daily Test Weight due for today."
content type:HTML
]
}
It is set up so once a form is submitted the next day at 7am it will check to see if there is a record for the current date at Location."DFW"
If there is no record an email gets sent.
The script is working with one exception. When I execute it I get this pop up.
When I enter any value, it executes properly.
I attempted to use this script
input.ID = "10001";
but learned that system variables can not be updated.
Does anyone know how to fix this?
Thanks,
Thomas