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

06 May 2025 v_Pipeline = ""; r_RecordDetails = invokeurl [ url :"https://www.zohoapis.com/crm/v8/Deals/" + p_DealID + "?fields=Pipeline" type :GET connection:"zcrm" ]; l_DealData = ifnull(r_RecordDetails.get("data"),List()); for each m_DealData in l_DealData {...

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

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

15 July 2025 to get the values to include in the invokeURL headers and payload. Previously on... m_Header = Map(); m_Header.put("Content-Type","application/json"); // // app specific (retrieving from a ZohoCreator record that stores all these credentials)...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 in your code editor add the code as per the below generic script when done, save 'widget.html' then return to terminal and type zet validate and then type zet pack this will create a zip file in a dist folder Login to ZohoCRM as a system administrator...

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

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

09 October 2025 is Module, Page is Create Page (Standard) (change this depending on if you're using a canvas or not) Module is Invoices Type is Page Event Event is onLoad Click on the button Next the Script /*...

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

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

19 September 2009 syntax: http://www.youtube.com/watch?v= Using the bookmark feature: Right 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 =...

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

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

05 December 2013 ps.person_name, ( 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...

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

Zoho Deluge: Convert Map to URL Parametershttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! What follows is the code I'm using to convert this: v_Endpoint =...

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

Zoho CRM: Make Upload File Field Mandatoryhttps://joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 Edit Page (Standard), and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My file upload field is called "Order Confirmation". v_OrderType =...

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

Zoho Creator: isBlank and isNull: Before or After?https://joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 v_Endpoint_Events = "https://api.github.com/users/joel-the-awesomest/events"; r_Events = invokeurl [ url :v_Endpoint_Events type :GET headers:m_Header ]; for each m_Event in r_Events { if(m_Event.get("id") != null) {... do stuff } } Source(s): Zoho...

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

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

06 February 2024 set Page=Detail Page (Standard), set Module=Contacts 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 =...

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

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

13 December 2023 function header below Category is "Module" Page is "Edit Page (Standard)" Module is "Products" Layout is "Standard" Event Type is "Page Event" Event is "onLoad" Click "Next" Method 1 This includes a function which counts the number of decimals. I didn't...

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

Using K2 with jezReCaptcha plugin causing errorshttps://joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 The Issue Basically that you've installed JoomlaEZ's ReCaptcha Integrator plugin to protect your forms ("type two words" captcha) and then installed K2 Comments to use it's own ReCaptcha. If you try adding a comment, you may get something like the...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 the "General" category link at the top of the module management list (not the "General" tab in the top left) At the bottom, type ROKBB3 then press the "Create new module" button. Make sure "enabled" is selected in the radio buttons and click on the...

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

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

25 February 2010 or need another developer to take over, you can at any point control which server your website visitors will go to when they type your domain name. Important: You only need the domain name and no additional packages (not even email as our servers handle...

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

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

26 May 2010 AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that...

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

Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties. Find your parameters in the Query. Check that there are no...

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

K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab Type the following query: REPAIR TABLE jos_k2_items Note that I say "jos_k2_items" because by default that's what it is... If...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 > Select "Add Table..." Add and specify the query as you would with any SQL query. (to create the dataset) Select the Report Type (for just a table with a heading row at the top, select "Tabular") > Next Click on "Details" until everything is added. >...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 name of the dataset. Bring up the tablix properties (or the textbox you want to hide) Select "Visibility" in the left margin Type the following expression (where "Equipment" is the name of the dataset) =IIF(Sum(Fields!Counter.Value, "Equipment") send to...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 the same thing as restart and reminded on both IT and environmental policies. Tech Notes: For PCs: Run a command prompt and type systeminfo: Look for "System Up Time". A staff member in a partner institution: "By the way my printer has stopped working,...

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