Related List to Show Relevant Data from Other Modules

Related List to Show Relevant Data from Other Modules

  1. //Get Account Details
  2. accountMap = zoho.crm.getRecordById("Accounts",accountId);
  3. //Get account Variables
  4. contactList = zoho.crm.getRelatedRecords("Contacts","Accounts",accountId);
  5. //
  6. rowVal = 0;
  7. responseXML = "";
  8. //
  9. if(contactList.size() > 1)
  10. {
  11. //prepare the XML
  12. responseXML = responseXML + "<record>";
  13. for each  contact in contactList
  14. {
  15. if(contact.get("Employment_Status") != "No Longer Employed")
  16. {
  17. fullName = ifnull(contact.get("Full_Name")," ");
  18. email = ifnull(contact.get("Email")," ");
  19. mobile = ifnull(contact.get("Mobile")," ");
  20. employmentStatus = ifnull(contact.get("Employment_Status")," ");
  21. responseXML = responseXML + "<row cnt='" + rowVal + "'><FL link='true' url='https://crm.zoho.com/crm/org80XXXXXXX/tab/Contacts/" + contact.get("id") + "' val='Contact Name'>" + fullName + "</FL><FL val='Email'>" + email + "</FL><FL val='Mobile'>" + mobile + "</FL><FL val='Employment Status'>" + employmentStatus + "</FL></row>";
  22. }
  23. }
  24. responseXML = responseXML + "</record>";
  25. }
  26. else
  27. {
  28. responseXML = responseXML + "<error>=><message>No Active Contacts</message></error>";
  29. }
  30. return responseXML;

    • Related Articles

    • Updating a Zoho CRM Subform (Accounts) from another Module (Deals)

      Updating a Zoho CRM Subform This script (courtesy of Zoho) will update existing records in a subform in one module (Accounts) from another Module (Deals). To create a cross-moduel subform entry (at creation for example), please see here ... ...

    • Mass Deleting Records In Zoho CRM using the API

      Pre-requisites Using Node.js In project folder install Axios (npm install axios) In project folder, install dotenv to use .env .create .env file .env File Structure CLIENT_ID=your_client_id_here CLIENT_SECRET=your_client_secret_here ...

    • Sticky Notes in Zoho CRM

      Sticky notes in Zoho CRM are a great way to quickly jot down details about a call, a task or any other information that needs to be easily accessible. These are personal notes and not visible to other users in your CRM account. Sticky notes are ...

    • IPT Connect with Zoho CRM (IP Telecom) - Admin and User

      IPT Connect with Zoho When you integrate your hosted PBX with your Zoho CRM, you can use the IPT Connect app to avail of the benefits of Zoho Phonebridge. With Zoho Phonebridge, you can manage incoming and outgoing calls. It also reminds you about ...

    • Finding Contact Role Ids in Your CRM

      Step 1: Setting Up OAUTH 1. Click Setup >> Connections >> Add Connection >> Zoho OAuth 2. Configure the connection as below: STEP 2: Functions | Create a New Function  & paste in the following code (change zohoapis.com to zohoapi.eu if applicable) ...