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

21 August 2012 This is to describe how to change the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing...

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

Access MySQL databases using Oracle SQL Developerhttp://mail.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 folder of your SQL Developer program Open SQL Developer, go Tools > Preferences > Database > Third Party JDBC Drivers and click on Add Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the...

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

Fix Oracle Tnsping 3511 without Windows Registryhttp://mail.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 Setting environment variables using the Command prompt (DOS) wouldn't stick (session only). My Fix Right-click on "My Computer" > select "Properties" Click on "Advanced System Settings" Click on "Environment Variables" Under "System Variables" modify...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 used by the jComments extension is easily automated and no longer blocks spam comments. Google's ReCaptcha is overrun by click farms and is unable to authenticate engaging visitors. How? So I have come up with what I consider a pretty stable solution. I...

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

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

10 December 2020 you select parameters to input rather than retrieving the record data: I'm calling the Function Name "RejectLeave" then click on Edit Params I'm calling the Method Name "OnValidate" and I add the following parameters: p_RequestID specified as "ID...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 Creator). 1. Setup up Zoho Oauth Connection: Go to connections (in creator this is icon in top-left > Setup > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope...

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 here was to simply repurpose a decision box field in Creator; then re-style it to look like a button; then add a workflow on click of this field. Set the form to reload the existing record when it is submitted (either on "Successful form submission", or...

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

Zoho CRM: Permission Denied for Quote Conversion Mappinghttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup Under "Customization", select "Modules and Fields" Click on "Organize Modules" Enable "Invoices" (by ticking the box and clicking on "Save") Hover the mouse over "Quotes" and select...

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

Zoho Books: Display Sales Order Shipping Address on Package Sliphttp://mail.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 Slip, so: Go to Settings > Templates > Package Slips Edit the template you want to change this on In the left button menu, click on Header Scroll down and click on Shipping Address Format (Custom) Enter the following placeholders:...

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

Zoho Creator: Change Radio into Tabshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 want to run some deluge (snippets below) every time the form loads, so I Go to Workflows > Form Workflows > Select your form Click on New Workflow Choose form (the one your radio tabs group exists on) (Record Event) Run when a record is Created or...

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

Zoho CRM: Template: Empty Space between Header and Line Itemshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-template-empty-space-between-header-and-line-items.html

03 February 2022 HTML of the template: Login to ZohoCRM > Setup > Customization > Templates > Inventory > Select the template with this issue Click on the "Edit HTML" icon in the top right of the editor: Find the code "page-break-inside" Change this from "avoid" to...

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

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

11 February 2022 layout didn't work Choose 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...

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

Zoho Creator: Radio group into Calendar Carouselhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 to the Zoho Bookings interface where their Creator app is to present the user with the days of the week which they can then click on to select a particular day. Some navigation is required in the form of a left arrow and right arrow to see previous or...

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

ZohoBooks: Stripe Terminal Integrationhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 take a payment. Why? Just to make it easy on the staff at a counter or on the phone. They bring up the invoie in ZohoBooks, click on the button, and the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in...

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

ZohoDeluge: Check Shipment Status via DHL APIhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 to Signup Complete the form with your details > Confirm via Email Create an app as described under Get Access section Click My Apps on the portal website Click on the App you created Note the API Key by clicking on "Show Key" The deluge function So this...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttp://mail.joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 to them Login to ZohoCRM Go to Setup (cog icon in the top right next to your profile picture) Under Channels, go to Email Click on the "Email Deliverability" tab Under Authentication, click on "Validate Records" Note the DKIM and SPF values as well as...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 WooCommerce in the left sidebar Go to Settings (in the menu/sidebar) > Advanced (tab) > REST API (link under the tabs) Click on the Add key button Give it a description, assign a user that it will run as (preferably of the admin or account that will...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 with the relevant data (in this case Zoho Books Analytics workspace) In the left sidebar, select "Data Sources" then click on the "Add Data Sources" button Select "Zoho Analytics Workspace" as the data source type. Select the relevant workspace and...

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

ZohoCRM: Make either Mobile or Email mandatoryhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 Required" Select the Email field as the primary field to control this rule Set the condition that the email "is empty" > click on the "Next" button Set Mandatory FIelds > and select "Mobile" Repeat these steps to add another rule: Call it "If Mobile...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 Feed management options can be hidden for standard admins. Check the current feed. Go to Banking > Selet the active account (click into it) and click the gear icon in the top right of this page (not the one next to your profile as that's global settings...

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