Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client wanted the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Schedule a Meeting using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 // // all day meeting m_ScheduleMeeting.put("All_day",false); // // meeting owner/host ID (can see any record related to this meeting) m_ScheduleMeeting.put("Owner",123456789012345678); // // related to what (in this example, a lead record but can be...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Embed Forms/Reports on a Pagehttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template snippet for a Zoho Creator page. We set the parameters of the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 the same database tables as Zoho Inventory, and there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other articles...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory: Mark a package slip as delivered and shippedhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 A quick article on a code snippet to mark a package as shipped and delivered in Zoho Inventory. Why? As usual, any task like this that takes me longer than an hour, I'd like to document for future use. The use-case is the client has their own delivery...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Generate a loop or list of any sizehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-generate-a-list-of-any-size.html

21 October 2022 This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Set Up a Widget Displaying Sales Personhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 to display a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the deals against a deal owner and needed to repeat this for all the invoices against a sales...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttp://mail.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 is that it is connected to the Internet unlike ChatGPT which only has information up to 2021. How? The basics of setting this up would be to setup a bot in ZohoCliq and then to edit either a message handler or participation handler. As for the usage,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: Inserting a new line character in a CSVhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 and instead would render/display it as "\n"... What I have Me,Myself,I\na,b,c What I want Me,Myself,I a,b,c How? So in this article I just want to list some various methods of inserting a new line character. Works on most systems: l_CsvFileRows =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Using Criteria with Module Record Counthttp://mail.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 the new API call "Module Record Count" with some criteria. Why? At time of print, I couldn't find an example of how to use this API call with search filters or criteria. Not sure about the rest of you, but I've been using this for pagination purposes...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 There is a deduplication feature for leads and contacts but not for products. How? There may be a better way of doing this. What I'm trying to have is a generic function that will work on any CRM and possibly be quick to adapt to a module other than...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 Looking for an online tool that will take an image and make a thumbnail copy? This article is for me if I ever want to recreate an online tool capable of receiving an image URL and which both generates and outputs a thumbnail image and makes it...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Prices get rounded up in Virtuemarthttp://mail.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 This happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card...

• Type: Article
• Author: Joel Lipman
• Category: Virtuemart
• Language: *

AutoHotkey Ternary Operatorhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 note for the moment on how to use ternary operators in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Border settings not saving in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 This may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Use T-SQL Like with a Parameterhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 This must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Set default parameter dates to start and end of monthhttp://mail.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 for some but anything that I spend 30 minutes googling and reading up on is asking for an article on my own site. Besides this is how I did it and what worked for me... Set the default values for your from and to date respectively: -- From Date...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

F_ck You. Pay Me.http://mail.joellipman.com/articles/web-development/fck-you-pay-me.html

14 April 2011 To be honest I saw this on some Joomlaworks Blog who appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco,...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Mouseover Links in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 this all about? Well I want the basic hover effect: when my mouse cursor hovers over a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How?...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

UNC Paths in Sharepoint 2007 linkshttp://mail.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 drive letter to the path? Then they won't be able to use the link. Why? As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms...

• Type: Article
• Author: Joel Lipman
• Category: SharePoint
• Language: *