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

26 January 2024 This is an article to document how to produce a report which when exported to PDF will display images without a user wall. Why? Our client needs to send a report to suppliers that include photos of the faulty products. These display fine in a Zoho...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 ZDK.Page.getField("Purchase_Rate").setValue(parseFloat(v_ProductCost).toFixed(6)); } catch (e) { // return error (don't display it, just show it in the logs) console.log(e); //ZDK.Client.showMessage("Client Script error"); } // unfreeze the GUI...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 prefilled in the field as soon as a contact is selected. How? This needs to behave like a formula field which changes and displays before saving the record. At time of print however, I can't get a formula field to retrieve a field from another CRM...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 => obviously by whether they're published or not... no idea why u would checked_out => sort by checked out (will either display or not on the front page so again not any use to sort by this) checked_out_time => just cos this value exists, don't know why...

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

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 is not before 2) Store both the formatted count and the value of column1.table in the next array entry Reverse this array Display the first 10 rows of this array (if we are doing a top ten) My new method is: SELECT column1, COUNT(*) AS CountOrder FROM...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 $a["Score"]; $bx = $b["Score"]; if ($ax == $bx){ return 0; } return ($ax > $bx) ? -1 : 1; } # get the words we're going to display function search_return_keywords($str) { $search = array ( '@ @si', // Strip out javascript '@ @si', // Strip out Inline...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 one screen. It's automation. The situation is that the program takes a picture of whatever that section of the screen is displaying. I made this program stay on top of all the other windows, much like the start menu/task bar (only this program is...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 WM_NOTIFYFORMAT = $0055 Const WM_CONTEXTMENU = $007B Const WM_STYLECHANGING = $007C Const WM_STYLECHANGED = $007D Const WM_DISPLAYCHANGE = $007E Const WM_GETICON = $007F Const WM_SETICON = $0080 Const WM_NCCREATE = $0081 Const WM_NCDESTROY = $0082 Const...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 "document.SearchForm.search_keywords.value") Or if you only know the elements name is search_keywords, you could display the value of that element using all, which references all the elements on the webpage: Code: javascript:...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 to left with a transition. Push existing slide out to the left; as soon as this is out of sight then hide it behind the displayed slide. Replace contents of the hidden slide with contents of the displayed slide. Hide currently displayed slide to expose...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 with a user through a computer network, with no transfer of a copy, is not conveying. An interactive user interface displays “Appropriate Legal Notices” to the extent that it includes a convenient and prominently visible feature that (1) displays an...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 using System.Text; using System.Threading; // for threading namespace JLDataFlowTransformations { [DtsPipelineComponent(DisplayName = "JL - to Mixed case" , Description = "Transforms selected text fields to Mixed case" , ComponentType =...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 no new updates for a plugin that comes with Joomla 2.5 install. How? Source: Joomla! • View topic - Cannot get recaptcha to display on registration form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 :: No File List - don't log file names. /NDL :: No Directory List - don't log directory names. /NP :: No Progress - don't display percentage copied. /ETA :: show Estimated Time of Arrival of copied files. /LOG:file :: output status to LOG file...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the page) as long as the end-user doesn't scroll. If the page was scrolled, what should...

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

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the drive and display the size of all the files/folders contained within. How? So I'll be putting this program for download from the download section...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to find...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 task) can only be used on a load of a form, on a change of a field or on the validate process. And because info can only be displayed to an admin and even in some cases only as an additional link in the form. The example below is for use in a customer...

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

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 input.Agent_Date_Time_End = input.Agent_Date_Time_Start.addMinutes(v_AppointmentDuration); } // // display confirmation text v_ResultInformation = " "; v_ResultInformation = v_ResultInformation.concat(" Customer: " + input.Name + " ");...

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