ZohoCRM: Process all records of a modulehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 v_CountFound = v_CountFound + 1; // // other field update if(!isnull(r_Record.get("Account_Name"))) { // do other stuff v_CountUpdated = v_CountUpdated + 1; } // // update the record irrespectively m_Update.put("Processed",true); r_Update =...

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

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

10 February 2022 // check that there is an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // stop looping if less than 200 records on this page...

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

Amazon Kindle: Send PDFs to your Kindlehttp://mail.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 Your Kindle. With the file now accessible to the Kindle, you can read it via the eBook reader as you would any other reading stuff. It’s true you need to go through an initial set-up process which essentially boils down to getting your email ID added to...

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

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

17 October 2022 != 0) { r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID,{"converted":"both","approved":"both"}); // // do stuff here such as updating the deal if required m_UpdateDeal = Map(); r_UpdateDeal = zoho.crm.updateRecord("Deals", v_DealID,...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 staff l_ApplicableStaff = Staff[ID != 0]; for each c_Employee in l_ApplicableStaff { info c_Employee.Name; // // reset the stuff they already have in their subform "Usual Shift" c_Employee.Usual_Shift.clear(); // // great now let's build a ZohoCreator...

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

ZohoCreator: Basic Widget with Zoho Datahttp://mail.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 All Rights Reserved the JavaScript These are the contents of main.js and is working at time of print: // Start with Zoho SDK stuff ZOHO.CREATOR.init() .then(function(data) { // Initialize var v_ShopifyID = ""; var v_ShopifyEmail = ""; var v_GreetingName...

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

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

22 July 2024 + " " + v_ThisDateEvent_Hour + ":" + v_ThisDateEvent_Minute + ":00"; // // date and time obtained... do your other stuff here } } } } // // get all future events // NB: status=open are upcoming events; status=closed are events in the past; status is a...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 all the rows." Need to include the criteria along with the columns and the "addIfNotExist" attribute Additional / Optional stuff to do but please don't waste your time. Out of sheer boredom: fn_GetMetaData_FormsFields v_NewLine = hexToText("0A");...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttp://mail.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 FROM a_pretend_table WHERE a_condition=true ) AS my_field_name FROM another_pretend_table T-SQL SELECT STUFF( ( SELECT ',' + column_to_return_as_string FROM a_pretend_table WHERE a_condition=true FOR XML PATH ('') ),1,1,'' ) AS my_field_name FROM...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB