Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 equalsIgnoreCase() which could be used:... l_ProductDetails = Product[Product_Name.equalsIgnoreCase(v_Name)];... Other Functions of Interest contains case-sensitive search, can be used on strings or lists containsIgnoreCase case-insensitive search...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 will then read what datatype of a parameter I'm sending to the function. So in "Edit this application" > go to Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 the connection link name (if you've already forgotten) Create a REST API Zoho CRM Function Go to Setup > Developer Space > Functions > New Function Give it a Function Name, I'll call mine fn_Shopify_Webhook_OrderUpdate Give it a Display Name, I'll give...

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

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 field to validate > Select "Lead Status" Choose validation type as "Validate using function" and click on "Next" For functions, select "Write your own" Give it a function name, eg. "fn_Validation_LeadStatusChange", a display name, eg. "Fn - Validation -...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 and did not receive even the email included in my custom function. Debug Method(s): Go to Settings > Automations > Custom Functions > Select the function > Execute the function against a paid invoice - check the fields updated. Go to Sales > Invoices >...

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

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 // // 7 returns '07' // 52 return '52' Source(s): Zoho Deluge: Built-in functions: Date-time functions: Type conversion: toString

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 Edit" Execute On: Create, Edit, Customer Reply No Criteria Under 4. Actions, I click on "All Actions" and select "Custom Functions" Click on the Plus icon alongside this, scroll down to "Custom Functions" and click on "New" I give it the function name...

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

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

10 February 2025 != null) {... do stuff } } Source(s): Zoho Deluge: Difference between isBlank(), isNull() and isEmpty() functions

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

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

28 September 2009 sensitive and spelt exactly the same way) Fatal error: Call to a member function acl_get() on a non-object in /includes/functions_display.php on line 135 sometimes line 82 or a blank page. We found this seems to be related to some Virtuemart modules we...

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

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

30 January 2011 privileges on the new database (only SELECT on the old database will do). Special care has been made to avoid the use of functions, stored procedures, temporary tables, etc. This allows broader compatibility and customers who do not have DBAs to run...

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

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

09 March 2011 $sanitized_search=(isset($_GET['search'])&&($sanitized_search==""))?trim(strip_tags(addslashes($_GET['search']))):""; # 2 functions to split up search terms and accepting double-quotes as phrase makers. function search_transform_term($term){ $term =...

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

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

29 March 2011 the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in T-SQL and you're confined to functions, temporary tables or little subroutines which just overcomplicates basic simple select queries... However set a counter to...

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

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

07 July 2011 comments/videos/pdf to be handled by existing Joomla! CMS features. I also needed a component which isolated the download functions external to Joomla! for performance purposes. What makes this one different to others, is that it it treats each file...

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

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 on that dimension? HAVING is pointless, WITH ROLLUP is interesting, think I'm looking in the wrong place. Using Aggregate Functions? What follows is the T-SQL Query I finally went with. Lots of numbers but I think this pretty much answered my question:...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) {...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 I need a function in it's simplest form and if I want to torture my successors, I'll complicate the function myself. How? Functions are supposed to return a single value, which is all I need in this case. In my example, I need to submit an Active...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me, the answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The equivalent functions have to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

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

07 September 2015 3.1 AdrianaV/Vincent- Enhancement: Does not display more images then are available. - Enhancement: Auto-Check for cURL functions enabled on server. - Fixed Bug: cURL_Init uses encoded weblink URL in case of spaces. - Fixed Bug: Auto-Update via Joomla...

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