Zoho Analytics & Zoho People: Monitor DataSource Sync http://mail.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure you setup a Connection that does NOT use the credentials of the logged-in user and has as scope...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 A quick article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 quote ID to the field "Converted From ID". Furthermore, fn_quotes_getquoteditems is a custom function (referred to in the code snippet below) in CRM that uses invokeURL to get the line items from the quote as well as the custom fields. /*...

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

Zoho Deluge: Connect to Shopifyhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 exists because I spent 2 hours going down the rabbit hole of trying to use OAuth2 and following the usual steps: Grant Code, Refresh Token, Access Token. I also went down the rabbit hole of installing app-bridge and configuring a JWT which was an...

• 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 internal name as fn_SubmitSuspectSurvey_Webhook and the parameter is a string called crmAPIRequest Give it the following code: string standalone.fn_SubmitSuspectSurvey_Webhook(String crmAPIRequest) { /*...

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

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 ZDK.Page.getField('Billing_State').setValue(o_QuoteDetails._Billing_State); ZDK.Page.getField('Billing_Code').setValue(o_QuoteDetails._Billing_Code); ZDK.Page.getField('Billing_Street').setValue(o_QuoteDetails._Billing_Street);...

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

Hide Menu Item from Registered and Special http://mail.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 like it was all part of one menu). toubkal wrote: This cannot be done by joomla administration but can be done by template code, you can have a module position in the template that is set to only show when the visitor is not logged in e.g. Code: Joomla...

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

How to use download managers with Google Chromehttp://mail.joellipman.com/articles/google/how-to-use-download-managers-with-google-chrome.html

19 September 2009 click on the bookmarks bar of Google Chrome. Type the name to what ever you want (eg. Download YouTube). Use the following code as the URL: javascript:window.location.href = 'http://youtube.com/get_video?video_id=' + swfArgs['video_id']+ "&l=" +...

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

Does Google Chrome Frame really improve performancehttp://mail.joellipman.com/articles/google/does-google-chrome-frame-really-improve-performance.html

23 September 2009 noticed a slight improvement in my page loads but will have to carry out proper tests on the weekend. Instructions to a hard-coder The Google Chrome Frame (or ChromiumBrowser) is quick to enable. Simply ask your webmaster to put the following meta tag...

• Type: Article
• Author: Joel Lipman
• Category: Google
• 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 ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle,...

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

Change div height to fit contenthttp://mail.joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a heading like this: I want this to...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 and set the layout if you want. Under Event Details, set Type=Page Event; Event=onLoad Click on "Next" Give it the following code: // attempt try { // get the ID of this record var v_ThisRecordID = $Page.record_id; // get the full name of this contact...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttp://mail.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 own website is glossy and dynamic. Very nice! Installing everything can cause a mess but otherwise nice solid and robust code.

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

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

14 April 2010 The concept - typically drawings, words, models, code and basic prototypes that describe the nature, objectives and features of the website. Design document - a detailed plan of the website’s features and how it will display are generated from the...

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

Joe's CSV Chart Generator (JCG)http://mail.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 It was created in AutoHotkey and the download includes the source file if you want to check it doesn't have any malicious code. INSTALLATION: Download the csvchartgenerator.zip from www.joellipman.com > downloads > Joe's CSV Chart Generator Unzip the...

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

RokDownloads Manager does not list fileshttp://mail.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 Do not uninstall/install other modules/components as I believe this is some issue with overloading or with the actual code and you can get to this file manager to work without changing your Joomla! setup. Watch this space for when I find a definitive...

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

Migrate Joomla! 1.5.x to 2.5.x+http://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 name of the new database -- including the new table prefix (Joomla 1.6.x, 1.7.x, 2.5.x, 3.0.x). -- Tip: I copy & paste this code into a text editor, then do -- "Replace All" with these 3 values, then copy & paste the resulting -- SQL into a query...

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

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

09 March 2011 ); $str = preg_replace($search, ' ', $str); $str = strip_tags(str_replace(array('[',']'), array(''), $str)); // remove BB Code and HTML tags $str = html_entity_decode( $str, ENT_QUOTES, "utf-8" ); // converts html entities into characters (symbols) $str...

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

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

07 July 2011 the features I needed. There were also standard features I wanted that didn't exist in the other systems. I wanted minimal code and leave the comments/videos/pdf to be handled by existing Joomla! CMS features. I also needed a component which isolated...

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