Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 connection:"zcrm" ]; l_SortedProducts = ifnull(r_CoqlSortedProducts.get("data"), List()); Source(s): Joel Lipman - ZohoCRM: Process all records of a module Zoho Deluge - Search Records in Zoho CRM Zoho Deluge - Get Records from Zoho CRM

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 use-case scenario mentioned earlier: first-line agents can't select a specific option in the Lead Status picklist: Login to ZohoCRM > Setup > Customization > Modules and Fields > Leads Select "Validation Rules" and cick on "New Validation Rule" Choose...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 work properly) Give it a name, I'm calling mine joel_creator Authorize it, etc. Create a REST API CRM Function Login to ZohoCRM Go to Setup > Functions > New Function Give it a name and such, I'm doing the following Function Name: fn_eBay_UploadPhoto...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 who clicks on the button). There might be an easier way to get the template ID used in CRM, but we did this by Login to ZohoCRM > Settings > Templates > Inventory Hover the mouse cursor over the template you want to use. Note or screenshot the url that...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 { if(r_Field.get("field_name") == "Deal_Ref") { v_DealRef = r_Field.get("field_value"); } } } } } } // // Search ZohoCRM for the Deal with that Deal Ref v_DealID = 0; if(v_DealRef != "") { l_SearchResults =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://www.joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was helpful on the CRM record to see how many candidates had been placed at this particular CRM Account....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: Inserting a new line character in a CSVhttps://www.joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 values (CSV) file given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... What I have Me,Myself,I\na,b,c...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance of Zoho Inventory. In this task, we are simply getting a CSV...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used ZohoCRM then this is obvious; if you haven't then it may be difficult to work this out. Put simply, "Closed" are events in the past...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 then return to terminal and type zet validate and then type zet pack this will create a zip file in a dist folder Login to ZohoCRM as a system administrator go to Setup > Customization > Modules and Fields > Accounts [or whichever module the button...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 the page names of your survey. GENERAL was the first page asking for lead/contact name when I have this prepopulated from a ZohoCRM integration. Also note that the question number comes from it prefixing the question per page that the client did when...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *