Been struggling with this for quite some time. I have a subform in a deal:
If a row has an Expiration Date that is in the past (two rows in red), then I need to update the "Liability" values on those rows to "0". I can't figure out how to do this with deluge.
I've gotten as far as being able to loop through each rows and identify which expiration dates are in the past, and I can put the existing Liability value in those rows in a variable, but I do not know how to update those Liability values to "0" on those rows.
record = zoho.crm.getRecordById("Deals",dealID);
subform = record.get("Claims_Service_Fee_Coupon");
if(subform != null && subform.size() > 0)
{
for each item in subform
{
expiration_date = item.get("Expiration_Date");
exptoDate = expiration_date.toDate();
if ( today >= exptoDate )
{
lineLiability = item.get("Liability");
info lineLiability ;
}
}
}
Any help would be greatly appreciated