You can fetch related records from a CRM module in Zoho Creator form using the getRelatedRecords() task. For ex, to get Notes associated with a given Potential id getRelatedRecords task should be used.
Syntax
zoho.crm.getRelatedRecords(<ModuleName>,<PrentModuleName>,<RecordID>,fromIndex,toIndex);
where,
<Module Name> is the name of the CRM module for which you want to fetch the related records.
<ParentModuleName> is the name of the parent module for which you want to fetch the related records. For example, if you want to fetch " Notes" related to a Potential, then "Potentials" is your parent module.
<RecordID> is the ID in CRM based on which the records related to the ID are fetched
<fromIndex>(optional)- Default value - 1
<toIndex> (optional) Default Value- 20 to 200
Resp=zoho.crm.getRelatedRecords("Notes", "Potentials", "747000000047001", 1, 3);
[
{id=747000000049029, Created Time=2011-10-03 10:15:35, Modified By= srividh, Title=notes8, Modified Time=2011-10-03 10:15:35,
Created By= ZohoTest, Owner Name= ZohoTest},
{id=747000000049027, Created Time=2011-10-03 10:15:27, Modified By= ZohoTest, Title=notes7, Modified Time=2011-10-03 10:15:27,
Created By= ZohoTest, Owner Name= ZohoTest},
{id=747000000049025, Created Time=2011-10-03 10:15:21, Modified By= srividh, Title=notes6, Modified Time=2011-10-03 10:15:21,
Created By= ZohoTest, Owner Name= ZohoTest}
]
Note:
You can define the getrelatedrecords() task using Script Builder by following the steps given below:
