Zoho ‐ Custom Related List - deptster/deptster.github.io GitHub Wiki
The objective is to show data of Lead -> Properties -> Lead (where '->' symbol is related to)
responseXML = "";
rowVal = 0;
count = 0;
if(prop_details.size() > 0)
{
for each prop in prop_details
{
lead_details = zoho.crm.getRelatedRecords("Leads11","Properties",prop.get("Properties").get("id"));
info lead_details;
if(lead_details.size() > 0)
{
responseXML = responseXML + "<record>";
for each related_list in lead_details
{
count = count + 1;
prop_name = related_list.get("Properties").get("name");
prop_owner = related_list.get("Leads").get("name");
responseXML = responseXML + "<row cnt='" + rowVal + "'><FL val='No'>" + count + "</FL><FL val='Property Name'>" + prop_name + "</FL><FL val='Property Owners'>" + prop_owner + "</FL></row>";
rowVal = rowVal + 1;
}
responseXML = responseXML + "</record>";
responseXML = "<count>" + rowVal + "</count>" + responseXML;
}
}
}
else
{
responseXML = responseXML + "<error><message>No related records found.</message></error>";
}
return responseXML;
responseXML = responseXML + "
<row cnt='" + rowVal + "'>
<FL val='No'>" + count + "</FL>
<FL val='Property Name'>" + prop_name + "</FL>
<FL val='Property Owner' link='true'
url='https://crm.zoho.com/crm/org763988065/tab/Leads/"+ related_list.get("Lead_ID") +"'>" + lead_name + "</FL>
<FL val='Lead Status'>" + lead_status + "</FL>
<FL val='Priority'>" + lead_pro + "</FL>
<FL val='Company'>" + lead_com + "</FL>
<FL val='Property Type'>" + prop_type + "</FL>
<FL val='Property States'>" + prop_states + "</FL>
<FL val='Lead Mobile'>" + lead_mob + "</FL>
<FL val='Lead Phone'>" + lead_pho + "</FL>
<FL val='Other Phone'>" + lead_opho + "</FL>
<FL val='Home Phone'>" + lead_hpho + "</FL>
<FL val='Email'>" + lead_mail + "</FL>
</row>
";