Search - Joel Lipman .Com

1. 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
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. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... ones m_CreateBooksItem.put("track_serial_number",true); m_CreateBooksItem.put("track_batch_number",true); // // let's try creating it r_CreateItem = zoho.inventory.createRecord("items",v_BooksOrgID,m_CreateBooksItem,"zinventory"); info ...; Created on 04 May 2023
10. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... if payment has already been recorded before creating a new one. - Fixed reference_number being included on customer payment. Date Modified: 2023-03-21 (Joel Lipman) - Added if conditions ...; Created on 27 April 2023
11. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... - GetOrders Documentation: https://developer.ebay.com/Devzone/XML/docs/Reference/eBay/GetOrders.html - eBay Errors by Number: https://developer.ebay.com/devzone/xml/docs/Reference/ebay/Errors/errormessages.htm */ // // ...; Created on 29 March 2023
12. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; What? A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...; Created on 21 March 2023
13. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... shared can be controlled/monitored. Create a CRM Module called "GPT Chats" (singular: GPT Chat) Modify the name field to be an Auto-Number (I'm prefixing mine with CHAT- Add a pick list called ...; Created on 06 March 2023
14. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an estimated number of products ...; Created on 01 March 2023
15. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
16. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per page: The ...; Created on 20 February 2023
17. ZohoCRM: Import Attachments: / Zoho /; ... := v_FilesTotal + 1 RowNumber := A_Index ;get first selected row RowChecked := LV_GetNext(RowNumber - 1 , "Checked" ) If ( RowNumber = RowChecked ) { v_FilesCopied := v_FilesCopied ...; Created on 16 January 2023
18. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... in the subform: // initialize var v_CalculatedNumberOfSkills = 0; // get the Opp stage var v_OppStage = ZDK.Page.getField('Stage').getValue(); // get the Skills subform var l_SkillsSubform = ...; Created on 09 December 2022
19. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... charges and other discrepancies. I'm calling this dataset "My Purchase Order Items" SELECT DISTINCT po."Purchase Order Date" AS "PO Date", po."Purchase Order Number" AS "PO Ref", poi."Produc ...; Created on 03 November 2022
20. 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