Search - Joel Lipman .Com

1. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is ...; Created on 07 May 2024
2. MS Excel - Open CSV with Long Numbers: / Excel /; What? This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ...; Created on 23 July 2019
3. Prefix Line Numbers in a Text File: / MS-DOS /; ... a new key with the action name (eg. "Prefix_with_line_numbers") Right-click on this new key and add a key to this one called "command" Under the "command" key, double-click the "(Default)" string in the ...; Created on 18 July 2012
4. Format Numbers in AutoHotkey with Commas: / AutoHotkey /; Just a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop ...; Created on 20 September 2011
5. 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
6. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a ...; Created on 25 March 2024
7. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the ...; Created on 13 December 2023
8. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("w"); v_ThisCurrentWeekNumberPadde ...; Created on 06 July 2023
9. 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
10. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode = ifnull(r_Result.get("payment_mode_formatted"),""); v_PaymentDate ...; Created on 17 August 2022
11. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... the first certificate file (the one with numbers, letters with extension CRT), copied the contents to clipboard then pasted under "Install an SSL Website" into the "Certificate" textarea field. Duplicated ...; Created on 07 April 2022
12. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... I'm aware of is a regular expression. So the first expression I came up with worked to a certain point but didn't round up the numbers, in other words, it didn't remove the unnecessary zeros. Note ...; Created on 08 February 2022
13. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; What? A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both ...; Created on 16 December 2021
14. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... - 1); } // // output info "[" + l_ProductIDs + "]"; info l_ProductIDs.size(); } Yields something like: [ 1234567890123, 2345678901234 ] 2 Well that produces a lot of ID numbers ...; Created on 12 October 2021
15. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... CRM and want to map the correct currency and tax by their ID numbers. How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run ...; Created on 24 September 2021
16. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have ...; Created on 03 June 2021
17. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; Applies to Joomla! CMS v3.5.x What? This is a short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have www.joellipman.com/index.php?option=com_content&category_id=4&article_id=123-article-alias // ...; Created on 14 March 2020
18. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something that can emulate a random number... well it's not ...; Created on 09 May 2019
19. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... the PHP $p_Name here is the title of your article or product that will be changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection here: function ...; Created on 06 May 2019
20. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = ...; Created on 25 March 2019