Zoho Creator: Input Color Pickerhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 } If a record is stored with its Hexadecimal value, when the record is loaded up (existing record), it will have the color already displayed in the button: Source(s): Joel Lipman - Zoho Creator: Radio group into Calendar Carousel Joel Lipman - Zoho...

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

Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 r_Delete = zoho.crm.invokeConnector("crm.delete",m_Delete); // // if error that product is already linked in a transactional module record. if(r_Delete.containsIgnoreCase("cannot be deleted") && r_Delete.containsIgnoreCase("involved in inventory...

• 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 will popup in a new tab. Right-click on the tab you want to hide and click on "Add Element ID" (or "Change Element ID" if already set). Call them something easy to remember such as "Tab_SalesPipeline" and "Tab_HirePipeline". Save and close the edit mode...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 above has a caveat in that it pushes the data from Zoho People to Zoho Analytics. It doesn't check to see if the data is already there, it doesn't update, it just keeps adding rows. Modify the function above (the one hosted in ZohoPeople) to account for...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 ZohoSurveys - Individual Responses Query (if using CRM to send surveys) If using the CRM integration, the Survey will already be associated with an email address. If not, then see the 2nd snippet of code. SELECT concat('REF-',...

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

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

13 October 2025 m_CrmLineItem.put("Tax",m_XeroLineItem.get("TaxAmount")); l_CrmLineItems.add(m_CrmLineItem); } } // // if the CRM Quote already exists, we are going to upsert so we need to remove the current line items in the CRM Quote l_SearchQuotes =...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 Availability Permission Issue: Are we logged in to Zoho Books as the super admin? Most likely yes and the client would have already checked this. Did this ever work before? Kinda pointless question but needs to be asked just in case this was never meant...

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

SSRS Report Builder 2.0 - Error during processinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design...

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

SSRS - Lost window with datasetshttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?) The menu link is "report data" and it's right at the bottom of the "View" menu.

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

Mootools - How to contain a menu sidebar between header and footerhttp://mail.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 $('jdo_actions').style.position = 'relative'; $('jdo_actions').style.top = '0px'; } } }); // still to do: smoothscroll? if already overlaps then flicks up

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

Display a thumbnail of a Google Drive videohttp://mail.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 Methods of getting the File ID #1 Right-click on the file and select "Get Shareable Link". If link sharing is already on, it will display a link such as: https://drive.google.com/open?id=, where is the file ID. If not the "Share with Others" dialog will...

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

Zoho Deluge - Get Current User IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

08 April 2019 ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer...

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