Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Option: Force no underlines on words. - Date Uploaded: Thu, 11th Nov 2010 1.2.3- Fixed bug: counts international characters rather than bytes. - Fixed bug: renamed functions so as not to conflict with any pre-existing ones (eg. utf8_strlen) - Date...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 access/refresh tokens and specified the appropriate scopes. The scopes I chose were to do with getting a working example rather than the recommended scope, though you may only need the first (untested): https://www.googleapis.com/auth/drive.file...

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

Zoho Deluge - Get distance between two coordinateshttps://www.joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 library figuring if it supports cos() then try this standard function. Note this has only been tested in Zoho Creator rather than Zoho CRM. How? This function returns the distance as the crow flies. Update 2020 Not sure exactly when but Zoho have made...

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

CSS Center an iFrame Horizontally and Verticallyhttps://www.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 and vertically in a screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 for which organization you are connecting to. If you get this wrong, you may access the wrong system (such as your own rather than the clients) or you may not access anything at all. Open a new browser window (preferably using the Google Chrome profile...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 subdomain of a company which has the domain joellipman.com. Why? This took me a bit of going backwards and forwards to Zoho rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties involved, plus...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 on line 86 Rather than assuming Zoho Deluge maps and lists are JSON variables, let's send a strange hack instead: m_NestedRequest = Map(); m_NestedRequest.put("auth[key]",v_AuthKey); m_NestedRequest.put("auth[secret]",v_AuthSecret);...

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

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

30 April 2021 This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar to when trying to enter a time against a project Task but...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 Clear subform of all its rows: input..clear(); Changing the picklist/dropdown options in a subform row (applies overall rather than per row): clear ..; ..

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

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 And if the account is integrated with Zoho CRM, the contacts will be pushed correctly as first name and last name rather than full name to last name: Source(s): Registration Form for Guest Users and Customer Portal Users

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 v_AddressIndex = v_AddressIndex + 1; } // check that there was something to actually update rather than wasting an API call if(m_ShippingAddress.size() > 0) { // endpoint TLD is EU for Europe DC and COM for US DC v_Endpoint =...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 + v_PhotoWithExt; } URL Syntax #6 [file]: Update 2023 Same again but this is for a field of type document/file rather than image. Where my form is called "My_Form" and the file upload field is "My_File": c_Document = My_Form[ID == 1234567890]; // // for...

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

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

22 October 2021 form. If you were to embed the form on to a page, you would be free to use some reserved CSS attributes on the page style rather such as position: absolute. Because I'm doing this inline and via code, Zoho automatically removes these. So instead, I am...

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

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

03 February 2022 are a lot of line items as per my screenshot here: How? This has been raised a few times by multiple clients but the fix is rather quick as long as you can get to the HTML of the template: Login to ZohoCRM > Setup > Customization > Templates > Inventory...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 task. Not anymore at least from what I've seen. You could try adding a subform to Creator but have it as a blank form rather than a bidirectional form as in this example, the parent record doesn't yet exist... The cheat here is that we actually want the...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 with MS Windows builds. Saying that, there are a lot of automations and applications I only know how to build in MS Windows rather than MacOSX.

• Type: Article
• Author: Joel Lipman
• Category: Articles
• 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 paid with (if paid by card). The customer wanted payment method and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields....

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 those credit notes for refunds, etc. This tweak is if we want to calculate credit notes issued in a particular month rather than the one-to-one with an invoice as profits in the past would change. So this table is created so that if a credit note was...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 Expecting ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried to make a subform equal the collection rather than inserting the collection into the subform using insert(). Invalid update task found corresponding properties: Trying to...

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 number of duplicates may easily differ to the loop of discrepancies simply because some records may be triplicates or more rather than just duplicates.

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