Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 outcome is the appending of a row to the subform based on the start date (first field in the subform) match in which case it should re-add the row with an "End Date" specified (blank or not). console.log("Joel Lipman - 20221018...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 YouTubers that had an effect on the output (ones I didn't make an image of didn't work for me but I want to remember them in case I learn how to use them): YouTube - Making the Photo YouTube - Future Tech Pilot GitHub - Willwulfken / MidJourney Styles...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run some Deluge code against it to...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://www.joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 to these instead. ZohoCRM: Get Details as Zoho User The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this article, this is how to get to them Login to ZohoCRM Go to Setup (cog icon in the top...

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

Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 This is an article documenting how to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead record to an opportunity (or Deal) record. If you are using...

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

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

14 October 2024 if they could be presented with a bunch of colors and they click on one to select it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most essential part of a...

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

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

06 May 2025 v_Pipeline = r_DealDetails.get("Pipeline"); } } } return v_Pipeline; } Give the argument/parameter "p_DealID" which in this 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...

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

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

18 August 2025 couple of days to simply install a JS widget hosted by Zoho and pass the record ID via a button to it, I'm adding it here in case I need to refer to it in future. Why? We have an Accounts module which holds all the companies we deal with in our Zoho...

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

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

13 October 2025 unsigned 19 digit integer) but that's more use when writing to Zoho Books. Within ZohoCRM, we only need the name and in this case the percentage rate: string standalone.fn_Xero_MapTaxRates() { /*...

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

Making a CD copy with only one drivehttps://www.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 This is in the case that you have only one optical drive which is a minimum of a CD Writer and you want to make a copy of a CD. Insert original CD in the drive In the CD Drive dialog box, click CANCEL On the desktop, double-click on MY COMPUTER...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

06 May 2010 Return to the Design interface of Report Builder 2.0 for the problematic report: Right-click on the reported DataSet (in my case: DataSet1) and select 'Dataset Properties' Select 'Parameters' and click on the duplicated field Click on the 'Delete'...

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

Comparing two mediawiki siteshttps://www.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 In this particular case, I'm comparing my Live and Dev versions of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours. Checking both MediaWiki have...

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

Functions to convert Hex 2 RGB and vice-versahttps://www.joellipman.com/articles/automation/autohotkey/functions-to-convert-hex-2-rgb-and-vice-versa.html

27 September 2011 _RGB1 _RGB2 _RGB3 StringReplace, HEXString, HEXString,0x,,All StringUpper, HEXString, HEXString Return, HEXString } Just in case, check a valid hexadecimal value: CheckHexC(HEXString) { StringUpper, HEXString, HEXString RGB:=HEX2RGB(HEXString)...

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

DBMS Random Referencehttps://www.joellipman.com/articles/database/pl-sql/dbms-random-reference.html

21 August 2012 data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1 can be: RANDOM VALUE STRING option2 can be: U (for Uppercase) L (for Lowercase) A (for AlphaNumeric) X (for Alphanumeric with upper case alphabets) P (for Printable characters only)...

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

Deserialization and cannot checkout files in TFShttps://www.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 file in the Solution Explorer Go to File » Source Control » Go Online The "Go Online" is the option I was missing in this case.

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more...

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

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`....

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

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

13 November 2018 A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below...

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

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

15 November 2018 the page breaks based on the paper size I select. I have a bit of HTML knowledge as well... ahem... well in this particular case CSS... so maybe this will help others: The culprit is the following CSS line: page-break-inside:avoid // change to...

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