Search - Joel Lipman .Com

1. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers ...; Created on 21 October 2022
2. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text to about 46pt and everything was over 3000px ...; Created on 22 February 2019
3. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... write an AutoHotkey program to simply return the folders in the drive and display the size of all the files/folders contained within. How? So I'll be putting this program for download from the download ...; Created on 28 January 2019
4. Php convert filesizes to bytes kb mb gb: / Personal Home Page /; What? Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays ...; Created on 03 January 2013
5. On Gui Resize Event: / AutoHotkey /; ... if you want to do something when a user resizes your program. If you search and search, you'll find that GuiClose responds to when you close the app, and GuiSize will run when you resize the app. Syntax: ...; Created on 09 November 2009
6. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... each index v_Increment in l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response ...; Created on 29 March 2023
7. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... != null) { l_Timings = r_Timing.get("business_timing"); m_ShiftRow = Map(); if(l_Timings.size()>0) { v_OpenTime = l_Timings.get(0); m_ShiftRow.put("open",v_OpenTime); } if(l_Timings.size()>1) { v_CloseTim ...; Created on 28 March 2023
8. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... ", ",").toList(); for each index v_Increment in l_AddPages { l_Pages.add(v_StartingPageIndex + v_Increment); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details ...; Created on 01 March 2023
9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... // send via Email v_CountRows = l_CsvFileRows.size() - 2; v_Subject = "Shopify Products Export & Comparison"; v_Message = "Please find attached a log of " + v_CountRows + " Product(s) from Shopify ...; Created on 20 February 2023
10. ZohoCRM: Import Attachments: / Zoho /; ... := "Date Created|Date Modified|Foreign Key|Zoho CRM ID|Original File with Path|New File with Path|Original Filename|New Filename|Display Filename|KB File Size" ; add gui Gui, New, -MinimizeBox -MaximizeBox ...; Created on 16 January 2023
11. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("ExternalPictureURL",v_PublicUrl); m_Params.put("PictureName","OhBeautifulMe"); m_Params.put("PictureSet","Supersize"); // / ...; Created on 31 March 2022
12. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; What? Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous ...; Created on 09 March 2022
13. Zoho CRM: searchRecords with sorted results: / Zoho /; ... stop looping if less than 200 records on this page if(l_SearchResults.size() < 200) { break; } } Method #2: zoho.crm.getRecords() // ****************** CODE USING GETRECORDS **************** // ...; Created on 10 February 2022
14. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... r = if(r_SendResponse.get("records").size()==1,"","s"); v_OutputMessage = v_OutputMessage + "Generated and sent " + r_SendResponse.get("records").size() + " file" + v_Grammar + " to " + r_ContactRecord.get("Emai ...; Created on 21 October 2021
15. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Well eBay returns URLs to images that have been resized to 400x400 (even with tweak to return 800x800). I wanted a way to upload my image directly to Shopify in 3024x3024 resolution (or the size that ...; Created on 17 October 2021
16. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... in r_GetProducts.get("products") { if(!isnull(r_ShopifyProduct.get("id"))) { l_ProductIDs.add(r_ShopifyProduct.get("id")); } } l_ProductIDs.sort(); v_LastID = l_ProductIDs.get(l_ProductIDs.size() ...; Created on 12 October 2021
17. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... = v_AddressIndex + 1; } // check that there was something to actually update rather than wasting an API call if(m_ShippingAddress.size() > 0) { // endpoint TLD is EU for Europe DC and COM for ...; Created on 22 September 2021
18. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... = v_SoapAction.toList("/"); v_Type = l_SoapActionParts.get(l_SoapActionParts.size() - 1); } } m_Blank = Map(); m_CreateRecord = Map(); m_CreateRecord.put("Event_Type",v_Type); m_CreateRecord.put("Payload",m_Payload.toString()); r_CreateRecord ...; Created on 20 September 2021
19. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... pure Deluge no Regex v_DelugeDate = null; if(v_TestDate.toList("/").size()>2){ v_DelugeDate = v_TestDate.toList("/").get(2) +"-"+ v_TestDate.toList("/").get(1) +"-"+ v_TestDate.toList("/").get(0); info ...; Created on 01 September 2021
20. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... split values by commas l_FieldValues = r_Data.toList(","); if(l_FieldValues.size()>0) { m_Record.put("EmployeeID",l_FieldValues.get(0)); } if(l_FieldValues.size()>1) { m_Record.put("Name",l_FieldValues.get(1)); } if(l_FieldValues.size()>2) { m_Record.put("Address",l_FieldValues.get(2)); } if(l_FieldValues.size()>3) { m_Record.put("Territory",l_FieldValues.get(3)); } info ...; Created on 26 August 2021