Search - Joel Lipman .Com

1. Xero API: Send Multiple Invoices: / Xero /; What? A really quick article for anyone who got stumped by the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more ...; Created on 15 August 2021
2. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; What? The aim of this article is to document how you can display a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through ...; Created on 06 December 2020
3. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; Applies to: Microsoft Windows 10 AutoHotkey 1.1.30 What? Yay for Microsoft Windows 10 in joining the rest of the Operating Systems in implementing multiple desktops. So if you have a Mac or Linux ...; Created on 18 July 2019
4. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; Applies to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. ...; Created on 09 August 2014
5. SSIS Multiple Lookups in one: / SQL Server Integration Services /; What? A quick article on an alternative to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" ...; Created on 05 August 2014
6. 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
7. Split a row into multiple rows based on a column value: / Transact-SQL /; Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that ...; Created on 23 August 2013
8. Delete related records from multiple tables: / MySQL /; What? So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead ...; Created on 11 January 2013
9. 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
10. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the total number of products (wp-admin > Products > All Products). Source(s): WooCommerce ...; Created on 15 April 2024
11. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... fields is equals. When you use "equals" for multiple conditions, and if one of your conditions is (Company:equals:ABC), the response will contain records with ABC as well as ABC Inc in their Company ...; Created on 14 November 2023
12. Zoho Books: System Values Maps: / Zoho /; ... DataCenter) from EU to COM as I was using this for a client on the US datacenter. I have a connection called "zbooks" and the v_BooksOrgID is the ID of the instance in ZohoBooks; so for multiple instances ...; Created on 07 November 2023
13. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
14. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... detailed, accurate representation, 3D Studio Max, V-Ray, professional, corporate, award-winning, realistic materials, accurate dimensions, multiple angles::3 deformed, abstract, unrealistic::-2 food: ...; Created on 11 February 2023
15. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... */ // // list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = ; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex ...; Created on 08 February 2023
16. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... ID with the PDF file attached to it. Also, you can send multiple PDF files at the same time, as it is with any email client. You can also use ‘Convert’ as the subject and send it to Kindle. The file ...; Created on 29 June 2022
17. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; ... tag which isn't great for CSS styling as you can't do cross-dom acoss child iframes; but it does let you use OpenURL(v_Url, "iframe", "iframe_name") which is good if you have multiple iframes on a page and ...; Created on 05 May 2022
18. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... (in PCIe 3.0 x16 Slot) from extending to multiple monitors (would only display 1 monitor or 2 mirrored monitors)... I solved this by taking the old GPU out and doing the steps listed in this article. Originally ...; Created on 12 March 2022
19. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple ...; Created on 10 February 2022
20. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; ... This has been raised a few times by multiple clients but the fix is rather quick as long as you can get to the HTML of the template: Login to ZohoCRM > Setup > Customization > Templates > Inventory ...; Created on 03 February 2022