Sending Info to Custom Module Using Function
Hi,
I have set up a custom module called "Entities" in Zoho CRM. Each Entity record can be linked to several Product Records.
I want to write a function which will sum the "Amount" fields from every Product record associated with the Entity and then update the "Total Entity MRR" field in the Entity Record with the total. I have already written a function which does a similar thing with Accounts and Products which works well, but I can't seem to get it to work with Entities. This is the code I have so far:
I want to write a function which will sum the "Amount" fields from every Product record associated with the Entity and then update the "Total Entity MRR" field in the Entity Record with the total. I have already written a function which does a similar thing with Accounts and Products which works well, but I can't seem to get it to work with Entities. This is the code I have so far:
resp = zoho.crm.getRelatedRecords("Products","Entities",EntityId.toLong());
//info resp;
total = 0.0;
for each rec in resp
{
total = total + ifnull(rec.get("Amount"),"0.0").toDecimal();
}
info total;
updateResp = zoho.crm.updateRecord("Entities",EntityId.toLong(),{"Total_Entity_MRR":total});
info updateResp;
Would someone be able to assist with this?
Topic Participants
charlie.gearon
Ishwarya SG
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Orchestly Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー