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 image field, links to another Zoho app that is behind a user wall (ie. login and password as a Zoho User). How? So I'll go over what happens in the real world process; then cover some technical information; and even include the function that makes it...

• 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 Created: 2024-05-13 (Joel Lipman) - Initial release Date Modified: 2024-05-14 (Joel Lipman) - After the 3rd reminder (3 days overdue) then assign to Dan (set as a separate workflow 4 days after creation of lead? Ensure that when this has been converted...

• 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 and select "Add Column" > I called the column "ZohoAnalytics Image URL" and gave it the data type of "URL": Now to copy over the image URLs, I duplicated my web-browser tab (right-click on the browser tab if using Google Chrome and select "Duplicate")....

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 m_Response.put("status_code",200); } // // return webhook response return {"crmAPIResponse":m_Response}; Once saved, I'll hover the mouse over it and click on the ellipsis to select REST API option. Then make a note of the URL. the ZohoBooks Estimate...

• 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 case will be a string. Use the # symbol to map it to "Deals.Deal Id" Save and close the function In the list of functions, hover over the function you just made and select "REST API" Enable both OAuth and REST API Click on "Save" to close the dialog box...

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

Zoho Survey: Zoho CRM Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 just wanted to record how to receive a Zoho Survey response in a Zoho CRM REST API function. Why? As above, didn't want to overload a single article with all the answers of one development but this one may be referred to separately. I want a Zoho Survey...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 Thought I already had an article on this and I know my article Zoho Deluge - Connect to Xero API covered a quick query to pull some invoices but this one documents a pull and mapping into CRM invoices. Why? This took me a whole afternoon so I wanted a...

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

404: Page Not Foundhttp://mail.joellipman.com/static-items/404.html

11 February 2015 new website at www.joellipman.com. The Page you are looking for doesn't exist or an other error occurred. Go back, or head over to Joel Lipman .Com to choose a new direction.

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

Welcome to my website!http://mail.joellipman.com/articles/web-development/welcome-to-my-website.html

19 March 2011 websites and scripts commercially since 1997 and I'm using this website to store notes as I go along. I specialise in taking over incomplete and/or bespoke systems which have little or no documentation. I like workarounds and solutions and persist in...

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

Comparing two mediawiki siteshttp://mail.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 from both sites and do an eye-check (I basically highlighted articles found in one but not the other - we had over 2000 articles... I guess I'm a bit geekly like that) This doesn't show modified date and content size differences but I can run this SQL...

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

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

Oracle: order by subquery missing right parenthesishttp://mail.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 ps.person_name, ( select txt from ( select pa.person_text as txt, pa.person_reference as personid, row_number() over (order by pa.last_modified_date desc) r from Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' ) where personid =...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

DJI Phantom FC40 - First Flighthttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-first-flight.html

28 August 2014 I just started another YouTube channel which I'll try to transfer my Joomla videos over to but in the meantime you can be subjected to my quadcopter videos. Here are a few quick ones, the Hubsan H107C and its Q4 Nano, then the DJI Phantom. First up, the...

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

SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 queries): SELECT COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the...

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