Hello all,
New to zoho creator and built one app for my company. Although I could get basics to work but stuck with one situation for now. Any assistance would be of great help.
Here is the overview of my forms
Users - (firstname, lastname, status, email, etc..etc..)
System - (systemname, category, etc. etc.)
Access - ( Users.email, System.systemname, access_status, access_date)
There is one default system (Google apps) that every user will have access by default, so I want to create a script for adding record in Access form for each user and that default system. I am trying to use for each rec and then insert into but its complaining about expression mismatch.
Please see following, and if you can help me figure out the issue.
for each fetchrec in Users [status == "active"]
{
logsys = System[System_Name == "Google Apps"].System_Name;
insert into Access
[
Added_User = zoho.loginuser
User = fetchrec.email
System = "Google Apps"
access_enable_date = zoho.currentdate
Request_Reference = "Initial Feed"
Access_Type = "Normal"
Access_Status = "Enabled"
];
}
I am getting this error : Due to invalid expressions insert statement is terminated
Not sure why.. but User field is asking for integer value and system name is asking for long value to be entered.