Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 2 status fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first time I'm using it so I'm documenting it. For this...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 not to try to update the form at all but instead to prevent the user from applying for leave in the first place: Create a validation custom function: Login to ZohoPeople as an admin, Go to Settings > Customization > Forms > Leave Under "Form Properties"...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 8th May 2013 2.0.0- Checked for compatibility with Joomla v2.5.x - Enhancement: SearchURL is html decoded/encoded for W3C Validation - Bug Fix: Line-height is adjusted to font-size - Removed jEvents integration - Date Uploaded: Fri, 7th Dec 2012 1.6.8-...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 individual elements. - Enhancement: Using div layers instead of tables. - Fixed Bug: Switched CSS ID tag to CLASS for W3C Validation. - Fixed Bug: Now allows description inline with popup (strips HTML). - Fixed Bug: Removed duplicate slash in weblink...

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

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 this is a comment */"; v_MyFormattedString = v_MyString.replaceAll(v_MyRegEx,""); // yields String to output: Zoho Deluge Validation Checking by Regular Expression: So I could do it the long way in Zoho Deluge. We match a pattern and replace everything...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 your Notification Endpoint URL, which must use 'https' and be accessible to you, and ensure it can respond to eBay's validation challenge code. In the Verification token field, enter a unique 32–80 character token containing only letters, numbers,...

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

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

13 December 2023 more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the record, they will get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 has file in -- -- also note that this form can work with simply the core mootools script -- but does not include the validation that is in the more mootools script. for Yootheme: Warp 6: Yootheme template: -- note that Yootheme warp does not include the...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 } // This method is called during Design Time when the component is added to the data flow public override DTSValidationStatus Validate() { bool pbCancel = false; IDTSInput100 input = ComponentMetaData.InputCollection[0]; string errorMsg1 = "Invalid...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 prompt. (your safari browser can not display this page anymore) Type: zet validate You should get a response saying that Validation Rules passed successfully. Now Type: zet pack You should get a response saying something like “Extension packed...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 validate the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter than Zoho's. Setup a Zoho CRM Function: Login to Zoho CRM > Setup > Functions > New Function...

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

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except...

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

Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 to: Joomla! CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true or false...

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