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

13 December 2023 script which runs when the product page is being modified: Login to ZohoCRM as a system administrator Give it a name, I'm calling mine "Products - Correct Decimals" Give it a description, I'm giving it the one I have in the function header below...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 Script" Click on "New Script" button (the blue one - not the "Add Script" grey one) Give the client script a name, I'm calling mine "Extra Confidential" Keep Category=Module, set Page=Detail Page (Standard), set Module=Contacts and set the layout if you...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 during the day (but not enough to be banned): Login to ZohoCRM > Setup > Automation > Schedules > Create New Schedule I'm calling my schedule "Shopify - Check Webhooks" and I'm going to execute a writing function. It has a function name of...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 4 (4 days not 4 business days?). Though I've removed this condition since go live and simply specified "All Leads". I'm calling my function fn_Leads_FollowUpNonConverted with the parameter being the Lead Record ID: /*...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 of creating a REST API function in CRM Login to ZohoCRM > Setup > Functions > New Function Give it a function name, I'm calling mine fn_ZohoBooks_Estimates_AcceptDecline with the parameters: p_Intent (string), p_QuoteRef (string), p_CxID (string) The...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 with only 1 error where it mixed a method with a comment but thereafter, a working script every time. The PHP Script: I'm calling it thumbnailer.php Deploy the Script Place thumbnailer.php into a web-accessible directory on your server (for example,...

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

Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

01 October 2025 but here goes a quick recap: Login to ZohoCRM as a user who has permission to create functions Create a CRM function, I'm calling mine "Fn - Submit Suspect Survey - Webhook" with internal name as fn_SubmitSuspectSurvey_Webhook and the parameter is a...

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

Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 Login to ZohoCRM > Setup (cog icon next to profile photo) > Developer Hub > Client Script > New Script Give it a name, I'm calling mine Invoice TBC Give it a description. I said "Sets the subject/name of the invoice to TBC when first created. Maps...

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

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

09 October 2025 v_TenantID = ifnull(r_TokenDetails.get("Tenant_ID"),""); // // get access token (does not need REST API url as we're calling it from within CRM) v_AccessToken = standalone.fn_API_GetXeroAccessToken(); // // do Xero stuff if(v_AccessToken != "" &&...

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

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

13 October 2025 v_TenantID = ifnull(r_TokenDetails.get("Tenant_ID"),""); // // get access token (does not need REST API url as we're calling it from within CRM) v_AccessToken = standalone.fn_API_GetXeroAccessToken(); // // do Xero stuff if(v_AccessToken != "" &&...

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

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/else/app-dev/android-os/messagebox-or-alertdialog-in-android-java.html

20 October 2014 the hint text of a specific user input field (EditText) Store the input in a TextView (invisible or visible) held in the calling XML /* 201411041253 */ private String hangar_aircraft_name; public void editHangarAircraftName(View view) { // get current...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

19 January 2012 Internal .Net Framework Data Provider error 30 - Wrong datatypes I was told but found this is just how I was calling the parameter. I declared these in the stored procedure but the fix in the end was referring to the Query Parameter Value properly....

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

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

30 July 2020 Status ms-settings:network-status ms-settings:network VPN ms-settings:network-vpn Wi-Fi ms-settings:network-wifi Wi-Fi Calling ms-settings:network-wificalling Personalization Background ms-settings:personalization-background Choose which folders appear...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will...

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

Zoho CRM: Client Script: Swap Quote Account with Deal Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-swap-quote-account-with-deal-lookup.html

20 January 2026 Login to ZohoCRM > Setup (cog icon next to profile photo) > Developer Hub > Client Script > New Script Give it a name, I'm calling mine Quotes - Map Distributor/Reseller Give it a description. I said "Maps the distributor/reseller from the opportunity...

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