Subform loop not listing all records

Subform loop not listing all records

Hi,

We have a script that should transfer subform records from one module to another subform in another module, but it is only pulling the last record and looping it in the other module.

Please see script below and advise on how we can modify it to pull in and transfer all subform records.


  2. Deal = zoho.crm.getRecordById("Deals",DealID);
  3. //info Deal;
  4. //Deal subform data
  5. subform = Deal.get("Credit_References");
  6. data = Map();
  7. formlist = List();
  8. //formlist.add(data);
  9. for each  subRow in subform
  10. {
  11. data.put("Company_Name",subRow.get("Name_of_Supplier"));
  12. data.put("Location",subRow.get("Location"));
  13. data.put("First_Name",subRow.get("First_Name"));
  14. data.put("Email_1",subRow.get("Credit_Reference_Email"));
  15. data.put("Last_Name",subRow.get("Last_Name"));
  16. formlist.add({"Billing_Details":subRow.get("Credit_Reference")});
  17. //formlist.add(data);
  18. }
  19. //info formlist;
  20. //fetch Contract Mangagemnt Records associated to the opportunity
  21. contractRecords = zoho.crm.getRelatedRecords("Contracting","Deals",DealID);
  22. //info contractRecords;
  23. //This assumes one contract per opportunity - get the contract record id
  24. for each  contractRecord in contractRecords
  25. {
  26. contractId = contractRecord.get("id");
  27. //info contractId;
  28. }
  29. //Note, this will overwrite the credit references from the opportunity
  30. // Update contract subform with opportunity subform data
  31. subformParam = Map();
  32. subformParam.put("Billing_Details",formlist);
  33. subformResponse = zoho.crm.updateRecord("Contract_Management",toLong(contractId),subformParam);
  34. info subformResponse;

Thanks,
Jason