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

13 December 2023 this can be an annoying overhead, especially if it can be auto-corrected with a client script. Pre-amble For both of the methods below, you will need to setup a client script which runs when the product page is being modified: Login to ZohoCRM as a...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which I found on the web and can be applied if you work somewhere that doesn't care about testing, about changing a...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to find...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 I've successfully subscribed without this. I'm just including it because I want to be notified if feedback is left: OAuth Method (requires contacting eBay to enable this once run) void API.fn_eBayQuery_SetNotificationPreferences() { /* Function:...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 connection:"zcrm" ]; info r_QuoteDetails; } Creating a record Pretty much the same as above but instead of the method/type PUT you will use POST with an endpoint of https://www.zohoapis.com/crm/v7/Quotes. Showing Off Just a note here for myself where...

• 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 Equals Blank is FALSE */ I've tried this in both Zoho Creator and Zoho CRM with the same results. I don't code with the method appended at the end of the variable but in more complex method chaining, I can see myself accidentally doing this. It's more...

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

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 is at the top of the list print out each row with the number of times that particular data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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

29 March 2011 If you're bugged by the warning "Overlapping report items are not supported in all renderers" then I'd suggest you use method #1. Issues I ran into: I replaced the empty dataset with the message "None" using Method #2 above. I noticed when a textbox is...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 of this tutorial is to teach the intermediate AHK user how to start using COM to control webpages. My goal is to provide methods for controlling webpages, similar to how the AHK Control Commands can control Windows Applications. This tutorial is going...

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

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

27 January 2013 lets you build up the queries which admittedly is cleaner and more organized. Here is a query which shows the building methods: // Get a db connection. $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // build the...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method: phpMyAdmin So in the phpMyAdmin interface, apparently, you can drag the columns by clicking and holding on the headers when...

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

Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

06 March 2014 456789 567890 597890 I want the third column to say whether this is new or not. How? I found this in a StackExchange site: Method #1 =MATCH(B2, $A$2:$A$100, 0) -- Check whether value in B2 exists in range of A2:A100. -- Returns the index of column A in...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 a command prompt to a) create a batch file b) use it to rename the files c) delete the batch file. Open a command prompt: Method #1 Open windows explorer to the folder you want to apply this to Hold down the shift key and right-click on the folder...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 A standard function that is skipping the SSL checks and returns a PHP array function send_request($url, $header, $data, $method="GET") { $ch = curl_init(); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST,...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 the Creator app to another person and adding our previous Super Admin account as a "Developer". How? I'm going to demo two methods here using the Setup the Connection Link Login to ZohoCRM as the creator super admin/owner (might not be the same as CRM...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object Query...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 Drag a single-line field and a multi-line field onto the form called "Title" and "Content" respectively. If you use this method to populate your notifications, you can send the ID of the record to show On the Creator page, retrieve the title and content...

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

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

12 October 2021 forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement and perhaps if I find a better way to do this, then I'll put it here. But I like this snippet of...

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

Zoho Books: System Values Mapshttps://www.joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

07 November 2023 } } info m_NominalAccounts; // // --------------------------------- // get delivery methods r_DeliveryMethods = invokeurl [ url :"https://www.zohoapis.com/books/v3/deliverymethods?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ];...

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