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

14 November 2023 datetime, text, textarea, integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted fields is equals....

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 signature with a profile photo included. When sending an email from CRM, they want CRM to include this rich signature (different per user) at the bottom of the email message. How? So there are a few issues with displaying images which would have other...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttp://mail.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 This is about enough time to store the record but that's it. Processing the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with...

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

Zoho Creator: Render to PDF with margins and page numbershttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 is for a customer who simply wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table with rowspans and the borders need to merge...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 repeatedly reminding but only to perform the task once. Incorrect Time: In my case, this was due to the CRM being set to a different timezone (7 hours off) and for testing purposes, I need to add the second parameter of toString() to a desired timezone....

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

Zoho Analytics: Create a Monitoring System with Imageshttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 images or icons warning or advising of failures. How? The key trick to use here the ability for Zoho Analytics to display different images based on a criteria or a value within a data table. As documented in an earlier article, put the URL of the image,...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 tag present with different colour already.","status":"error"} -> Error was due to someone already giving tags with the same name -> Solution is to remove the color_code key as well... m_Tag.remove("color_code"); */ Considering that neither the color...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 PDF brochure we send out to our customers... How? Well fulfilling the brief (whether it's the right tool for the job is a different issue), let us synchronize Zoho Surveys into Zoho Analytics. I found I need to edit the setup of the sync every time a...

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

Add "Command prompt from here" to right-click context menuhttp://mail.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 menu to display, I use Command prompt from here For the Application value type c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe program) Click on OK > OK > Close Notes: Added by default since Microsoft...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Code Troubleshooting Checklisthttp://mail.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 similar files in the same environment? Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation since the service...

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

PHP: First name and Initial of Surnamehttp://mail.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first thing I did was to create the logic: // default $author_name_disp=$author_name; // check and transform...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

SSRS Change Background Color of Imagehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 pixels will be colored in with the page background color. Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the...

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

Forgotten Super User Password in Joomla 2.5.x - 3.xhttp://mail.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

06 February 2015 on how to set a password using the database tools for super users. Why? It happens to us all, especially me. I like to use different passwords for every site but this came up as a client had lost their super user password. How? This method is reliant on...

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

Zoho Deluge - Get Current User IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

08 April 2019 This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So...

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

Zoho Deluge: Generate and Send a CSV via Emailhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 v_Subject message: v_Message attachments:file:v_CSVFile ]; Issue(s): CSV being returned in a single line, consider different methods of inserting a new line: Joel Lipman: ZohoDeluge: Inserting a new line character in a CSV

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