Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this...

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 I thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 system registry in MS Windows, you may need to find someone who is. How? As a proof of concept, let's see how to hide a specific drive. Note that this section applies to the currently logged-in user. To restrict other users, see the example after this...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 to this field so we can reference it later. style="color:grey" - add a styling to it by default (on initial load), in this specific case the color grey. value="Name:" - give this field a default value. In this specific case, we are giving it the label...

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

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 it. For this example, we're going to use my use-case scenario mentioned earlier: first-line agents can't select a specific option in the Lead Status picklist: Login to ZohoCRM > Setup > Customization > Modules and Fields > Leads Select "Validation...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 form. A “Major Component”, in this context, means a major essential component (kernel, window system, and so on) of the specific operating system (if any) on which the executable work runs, or a compiler used to produce the work, or an object code...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 $row[1]; // the retrieved value of "email" $this_user_username = $row[2]; // the retrieved value of "username" } -- for a specific value of a row $a_user_email = $rows[2][1]; Multiple Row Results - loadAssocList() This type of query is for when you want...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 and noun/adjective/verb forms. Referencing: If this is a search system for a technical database, and there is one specific article you visit a lot, it would be nicer just to type a number like "1234" and this returns that specific article. In the case...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 for staff only. REST Admin API: Usage: Here's a quick test I do retrieving 5 products using the REST admin API: // // app specific r_ShopifyAPI = API_Integration[Connection_Name == "Shopify API OAuth"]; v_ShopID = r_ShopifyAPI.Shop_ID;...

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

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 DateFormat.ShortTime) Unfortunately if you are using US dates and want the report to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the...

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

Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 should remain lowercase. How? The SSIS Script component task has to be generic, it should only apply this to columns we specifically tick in a package and we should be able to use the same script in any package... eek! Either of the two following script...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 Class The POSIX character class operator lets you search for an expression within a character list that is a member of a specific POSIX Character Class. You can use this operator to search for characters with specific formatting such as uppercase...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 console along with the redirect URI being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... // specific to this app $CLIENT_ID = ''; // expecting *.apps.googleusercontent.com...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 Google Chrome Profiles Even more final than lastly: Suppose you didn't opt to create a desktop shortcut when creating a specific user profile in Google Chrome or you've deleted it and don't know what the profile number is: To create another desktop...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url":...

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

Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 (one that regenerates an access token or reuses if not expired). Thereafter, I use the GetMyeBaySelling API Call with specific criteria to only return the active listings as well as specific fields so my function doesn't get overwhelmed with the amount...

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

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 to manage a subform using a Zoho CRM Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 in the top right) Under Zia, select "Conversational AI" Click on the link "Zia Developer Console" (yours will have the specific OrgID in the URL). Click on "Add Action" Give it the Action Name "Ask ChatGPT" This action should "Answer a Question" It...

• 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 An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green...

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