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 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 Creator report and even show up on the preview when exporting to PDF. But when you download...

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

Zoho Inventory Template Issue: First Page is Blankhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the...

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

Zoho Deluge: Nested Catch Statementshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 try { v_Test2 = "Bar"; info v_Test2.toLong(); } catch(e) { info "Couldn't convert 'Bar' to an integer"; } } Pushing the product beyond it's design Note that before anyone says I'm only try catching a doomed conversion from string to integer; I've...

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

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

13 December 2023 fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than...

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

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 TEU. You are not allowed to use the member list to obtain Instant Messenging screennames to harrass people to purchase a product from you. No Illegal Activity - You are not allowed to break the law using TEU. This can get TEU into legal trouble. Posting...

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

Project Plan for Freelance Websitehttp://mail.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 any images, videos or files that will be included in the project and that our design and direction should focus on. The end product will revolve around what you submit here. For you to do: Submit drafts or sketches (rough layouts - can be on paper in...

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

Some milestones for a website projecthttp://mail.joellipman.com/articles/web-development/some-milestones-for-a-website-project.html

14 April 2010 features in and working, this allows reviewers to get a feel for the site, the level of usability, the saleability of the product and technical risk involved in fully developing the website. ALPHA/BETA – these are the next major milestones that...

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

Joes Bug Tracker (JBT)http://mail.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 --- Protect storage folder (only accessed through Joomla!?). --- Integrate JComments/Integrate Facebook Comments (for Product Reviews/Feedback). --- Auto-increment minor/major version number / Assign naming convention. --- Date Format for files (mysql...

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

Excel PivotTable Filter List Orderinghttp://mail.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 "Report Filter" Done! The filter dropdown should retain the order. Alternatively Similar to the above, open a Microsoft product Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the...

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

Proposed Budget i3 PC under £200http://mail.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 skip Windows 8 and wait for Windows 9, but in the meantime we need something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core CPU (...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Export/Import Database using MySQL Workbenchhttp://mail.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the...

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

Compare two databases using T-SQLhttp://mail.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and binged and all I could find were people selling third party products... they don't get it. If you are...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As my work was for a Personnel/HR project, and data confidentiality is somewhat important, some of the...

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

Quadcopter App with Flight Restrictions (JQA)http://mail.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 injury to others, including that to life and health, resulting from any application and use of any of JoelLipman.com products. The Purchaser and any Pilot in Command (PIC) assumes full and unlimited responsibility for all applications and uses of any...

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

Joes Search Module (JSM)http://mail.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 Download You can download this module I made from my download section at http://www.joellipman.com/features/downloads/product/20.html or search my site for "Joes Search Module" (or "JSM"). Other Areas: One of the parameters is entitled "Search Area"....

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

Migrating from Joomla 2.5.x to 3.4.xhttp://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 CMS and running MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running Joomla v2.5 as "v25" and the new Joomla instance as "v34". Their respective database tables are...

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

URL Alias uniqueness with PHP & MySQLhttp://mail.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 | \----------|-------------------|----------------------/ the PHP $p_Name here is the title of your article or product that will be changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection...

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

Zoho Deluge - Get Refresh/Access Token API v2http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 but also if your endpoint is going to .COM instead of .EU (or vice-versa). You can check this by logging into your Zoho product (eg. CRM) and looking at the top level domain // If your CRM is accessed by visiting https://www.zoho.com/eu or...

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and...

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

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

14 July 2020 (prerequisite: enable the field to allow Image as "Link" not just "Local Computer" or "Camera"): for each r_Image in m_Product.get("images") { if(!isnull(r_Image.get("src"))) { if(isnull(v_MainPhoto)) { v_MainPhoto = "

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