Search - Joel Lipman .Com

1. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page of Copyright © My ...; Created on 07 May 2024
2. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday ...; Created on 06 July 2023
3. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... to the same school and updates some number fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was ...; Created on 19 October 2022
4. 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
5. MS Excel: Convert a text to a number: / Excel /; What? This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...; Created on 15 November 2013
6. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; What? So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- ...; Created on 04 June 2013
7. T-SQL concatenate an incremental row number: / Transact-SQL /; ... "Joel Lipman" has a degree in Computer Science BSc and some qualification in being Superman. Specification The output expected by the customer is the following: EMP -------------------------------------------------- EmpNumber ...; Created on 24 May 2013
8. Prefix Line Numbers in a Text File: / MS-DOS /; Intro Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number ...; Created on 18 July 2012
9. Format Numbers in AutoHotkey with Commas: / AutoHotkey /; ... break } } Return Result } Use as per usual: ValueWithCommas:=FormatAddCommas(NumberWithoutCommas) One taken from the AutoHotkey forums: AddCommas(val) { ...; Created on 20 September 2011
10. Increase Recent Documents Number in Windows XP: / Windows OS /; Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked ...; Created on 28 July 2011
11. ZohoCRM: Make either Mobile or Email mandatory: / Zoho /; ... on a Zoho CRM contact record is used to authenticate the contact on a Wordpress portal. OTP or 2FA or MFA or OTC is in effect however; so a contact email OR phone number is required. Both aren't required ...; Created on 03 October 2024
12. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... e complete the following Credit Application Form or forward to the person within your company responsible for completing this."); m_Actions.put("recipient_phonenumber",""); m_Actions.put("recipient_countrycode",""); m_Actions.put("verify_recipient",false); m_Actions.put("recipient_name",v_RecipientFullName); m_Actions.put("recipient_email",v_RecipientEmail); l_Actions.add(m_Actions); ...; Created on 06 August 2024
13. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... to have to be asked directly to Zoho rather than using the online subscription plan management section. Statement Execution Limit is 5000 The following will run resulting in the error "Number of ...; Created on 31 July 2024
14. Zoho Projects: Get All Events: / Zoho /; ... are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index ...; Created on 22 July 2024
15. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... po."Purchase Order ID" AS "PO ID", po."Purchase Order Number" AS "PO Ref", po."Purchase Order Date" AS "PO Date", po."Purchase Order Status" AS "PO Status", poi."Item Name" AS "PO Item", poi."Ite ...; Created on 09 July 2024
16. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... to get workspace ID, look at the URL in ZohoAnalytics and take the number straight after the word "workspace/" v_WorkspaceID = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho Analytics, ...; Created on 02 July 2024
17. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... and vice-versa. And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the ...; Created on 23 May 2024
18. 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
19. 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
20. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... subform: void Standalone.fn_DownloadAndCacheAttachments(string p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,""); c_TicketRecords = QC_Report_Table[Ticket_Number == v_TicketRef]; for each ...; Created on 26 January 2024