Add multiple records from another form - deluge help needed
I know enough to be dangerous - thus i can't seem to figure out what i'm doing wrong here on this script. It won't let me save, saying error in line 1. Any help is appreciated
for each fetchrec in Client_Details [(Status == "Customer") && (Status == "Pending Termination")]
{
insert into Tasks
[
Status = "Open"
Due_Date = Zoho.currentdate
Title = "Process Pending Payments for" & " " & fetchrec.Management_Company
Task_Description = "Process Pending Payments and Post Lockbox"
Added_User = zoho.loginuser
Client_Details = fetchrec.ID
Assigned_to_Team = fetchrec.Team_Assignment
];
}