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 loops, then the next best thing I'm aware of is a regular expression. So the first expression I came up with worked to a certain point but didn't round up the numbers, in other words, it didn't remove the unnecessary zeros. Note that in the following...

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

Joel's Reference to MidJourney v4 Promptshttp://mail.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 it isn't MidJourney... But it's free. Defaulting some parameters to be added to every prompt /prefer suffix This defaults certain arguments to any prompt you submit. I don't really recommend this unless you're doing a batch of images which need to match...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• 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 then releasing the ALT key and save the change to your code. This will not display a character but is a new line... Used in certain cases v_NewLineChar = hextoText("0A"); Thought I needed to add the following but this makes absolutely no difference:...

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

ZohoDeluge: Check Shipment Status via DHL APIhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 asked, in this case Zoho Inventory. So for this, I've set up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: Login to ZohoInventory > Setup (Cog Icon) >...

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

Zoho Deluge: Determine if Daylight Savings are in effecthttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've covered this before in a fair few articles on...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 v_DocFileName = ifnull(c_Document.File_field,""); // // used for blocking certain file extensions (not used in this function) v_DocExtension = v_DocFileName.subString(v_DocFileName.lastIndexOf(".") + 1).toLowerCase(); // // All_Documents is the report,...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 A quick article with snippets of code to hide and show certain tabs on a deal record based on the pipeline. Why? A request from a customer asked if a tab specific to the pipeline selected can be shown while others hidden. Standard tabs such as Notes,...

• 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 it will load the first few images and as the user scrolls down the dropdown, more are loaded. This still gets buggy on certain mobile devices as some images are over 1Mb. So I needed a tool that every time a new product is added, a thumbnail gets...

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

Frontpage Item Orderinghttp://mail.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 me. The quick answer is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page...

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

Strip HTML in MySQLhttp://mail.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a MediaWiki CMS to a SaaS...

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

List last modified files using FTP Command-linehttp://mail.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 files including subdirectories to temp.txt in your local working folder. Additional Notes the switch "-S" does not work on certain systems (at least not accompanied with the command to output to a local file. Type dir . temp.txt to output the current...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Joes WebGL Experimenthttp://mail.joellipman.com/component/content/article/joes-webgl-experiment.html?catid=40

06 April 2013 Limitations Does not work in MS Internet Explorer Is not working on iOS and certain smartphones Advantages No copyright, watermarks and as configurable as revolvermaps Can feed any list of latitude/longitude. Working on... Image Switch and color...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *