Hi guys,
Could you please help with this?
BACKGROUND
----------------------------------
We have a form called "New Claim".
The form has a field called "Today_Field".
It also has a field called "Status".
SCHEDULE
----------------------------------
We have a daily schedule set up which updates "Today_Filed" with current date.
The code is below:
for each r in New_Claims
{
r.Today_Field=zoho.currentdate;
}
THE PROBLEM
----------------------------------
Right now, the schedule iterates for all records based on "New Claim" form.
We now have too many records on this form and we are exceeding the deluge script limit, which is causing the schedule to malfunction.
Rather than iterating the schedule for all records based on "New Claim" form, I only want it to apply to records where the "Status" filed equals "settled".
Can you please tell me how to make this code?
I can't seem to understand how the criteria function is supposed to work.
Thank you so much!