string related_list.Populate_Sales_Tiers(Int Rec_ID)
{
Pages = {1,2,3,4,5,6,7,8,9,10};
Match_Found = false;
responseXML = "<record>";
count = 0;
for each Page in Pages
{
Sales_Tier_List = zoho.crm.getRecords("Sales_Tiers",Page,200);
for each rec in Sales_Tier_List
{
ST_Rec_Id = rec.get("id");
rec_details = zoho.crm.getRecordById("Sales_Tiers",ST_Rec_Id);
Sales_Entries = rec_details.get("Sales_Entries");
if(Sales_Entries != null)
{
for each data in Sales_Entries
{
Reservation_id = ifNull(ifNull(data.get("Reservation"),{"id":""}).get("id"),"");
//info Reservation_id;
if(Reservation_id == Rec_ID)
{
info "Inside if:";
Tier_Month_and_Year = ifNull(rec.get("Tier_Month_and_Year"),"");
Name = ifNull(rec.get("Name"),"");
Tier = ifNull(rec.get("Tier"),"");
Total_Sales_Value = ifNull(rec.get("Total_Sales_Value"),"");
Tier_Record_Number = ifNull(rec.get("Tier_Record_Number"),"");
Sales_Manager_Booked_Unit = ifNull(rec.get("Sales_Manager_Booked_Unit"),"");
Incentive_Percentage = ifNull(rec.get("Incentive_Percentage"),"");
info Sales_Manager_Booked_Unit;
///////////////////////
///////////////////////////
responseXML = responseXML + "<row no='" + count + "'>";
responseXML = responseXML + "<FL val='Sales Tier Name' link='true' url='https://crmsandbox.zoho.com/crm/newsandboxeck/tab/CustomModule55/" + ST_Rec_Id + "'>" + Name + "</FL>";
responseXML = responseXML + "<FL val='Tier Month and Year' link='true' url=''>" + Tier_Month_and_Year + "</FL>";
responseXML = responseXML + "<FL val='Incentive Percentage' link='true' url=''>" + Incentive_Percentage + "</FL>";
responseXML = responseXML + "<FL val='Total Sales Value' link='true' url=''>" + Total_Sales_Value + "</FL>";
responseXML = responseXML + "<FL val='Sales Manager Booked Unit' link='true' url=''>" + Sales_Manager_Booked_Unit + "</FL>";
responseXML = responseXML + "<FL val='Tier Record Number' link='true' url=''>" + Tier_Record_Number + "</FL>";
responseXML = responseXML + "</row>";
count = count + 1;
}
}
}
}
}
responseXML = responseXML + "</record>";
return responseXML;
}
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter