Search - Joel Lipman .Com

1. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... the first is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // // create a string ...; Created on 21 October 2022
2. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; What? This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which ...; Created on 19 September 2021
3. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; What? A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I ...; Created on 11 January 2021
4. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill ...; Created on 30 November 2018
5. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; What? This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate ...; Created on 13 June 2014
6. A for loop within a for loop in MS-DOS: / MS-DOS /; What? A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line ...; Created on 03 October 2013
7. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
8. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... looping but only have 1 upload so getting permalink for this upload for each m_ThisData in r_UploadResponse.get("data") { if(!isNull(m_ThisData.get("attributes"))) { if(!isNull(m_ThisData.get("attributes").get("Permalink"))) { v_PermaLin ...; Created on 11 September 2024
9. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... statement execution limit exceed Line:(10)" but it will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info ...; Created on 31 July 2024
10. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... record. // // initialize m_Blank = Map(); // // evaluate v_BooksOrgID = organization.get("organization_id"); // // loop through line items for each m_LineItem in salesorder.get("line_items") { r_BooksItem ...; Created on 23 May 2024
11. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... :v_Endpoint type :GET headers:m_Header ]; if(r_ShopifyWebhooks.get("webhooks") != null) { // // loop through to see if our custom notifications exist // note that installing other ...; Created on 22 April 2024
12. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... How? So first, this article shows you how to setup an API connection, and then we'll include the code to count the total number of products, and then finallly show the code to loop through all the ...; Created on 15 April 2024
13. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... { // store the search results into an array var recordArr = response.data; // quick loop to find the preferred name ...; Created on 14 March 2024
14. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... image URL to/from ZohoWriter. Loop through active users in ZohoCRM. Merge the HTML email signature with the fields evaluated. Function: fn_Workdrive_HostImage I add this function to the CRM ...; Created on 05 December 2023
15. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working ...; Created on 14 November 2023
16. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records ...; Created on 12 July 2023
17. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... adding label because -3 often displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in l_SalesOrderLineItems { ...; Created on 06 July 2023
18. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... or create. - Loop through eBay payments to record all the different payments received. Date Modified: 2023-03-14 (Joel Lipman) - Resolved fix of incorrect customer (Use Email rather than ...; Created on 27 April 2023
19. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... now lets loop through a dynamic page list for each v_Page in l_Pages { // // specify which page m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); // // ...; Created on 29 March 2023
20. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... on the employee record So now we just need to append the following code which loops through the map / associative array we just created and shove this onto every employee's record. My employee recor ...; Created on 28 March 2023