I have a Creator form set up that acts as a calculator for Line Items in a CRM estimate.  I set up a function on Success which submits the added subform records as Line Items in an existing estimate using the updateRecord() function.  This works to an extent.... 

The issue is.. if there are more than one of the same product added as a Line Item it does NOT add the multiples.. it simply overwrites the first entry with the latter's values.  I understand why this is happening but I can not come up with a solution to prevent it.  I'm told there is a way to make what I need happen by parsing the information differently but I can't seem to get the syntax for this from anywhere or anyone.  I've experimented like crazy with rearranging the scripting.  Zoho support hasn't been able to help, nor has my associated Zoho partner.  This is holding up our implementation of CRM.

I can't imagine that I'm the first person to have this requirement.  Can anyone help please?!?!

Here's my current code:

crmid = input.Estimate_Number;

//info crmid;

estDet = zoho.crm.getRecordById("Quotes",crmid.toLong());

//info estDet;

finalmap = Map();

finalmap.put("Subject",estDet.get("Subject"));

finalmap.put("ACCOUNTID",estDet.get("ACCOUNTID"));

productsList = List:Map();

for each  row in input.Storage

{

Product_Details = Map();

/*Product_Details1 = Map();

Product_Details2 = Map();

Product_Details3 = Map();*/

prodname = row.Product.Product_Name;

//info prodname;

prodid = zoho.crm.searchRecordsByPDC("Products","productname",prodname);

Productid = prodid.getJSON("PRODUCTID");

//info "#####" + prodid + "**" + Productid;

Product_Details.put("Product Id",ifnull(Productid,""));

Product_Details.put("Quantity",ifnull("1",""));

Product_Details.put("List Price",ifnull(row.Total,""));

Product_Details.put("Product Description",ifnull(row.Notes,""));

Product_Details.put("Total",ifnull(row.Total,""));

//plist= {"product":{Product_Details},Product_Details2};

//Product_Details.put("product",{{Product_Details},Product_Details2});

//Product_Details3.put(Product_Details1,Product_Details2);

//info plist;

productsList.add(Product_Details);

info Product_Details;

}

info "/,/,/" + productsList;

finalmap.put("Products",productsList);

info finalmap;

resp = zoho.crm.updateRecord("Quotes",crmid,finalmap);

info resp;