Zoho CRM: Change System Field Lengthhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead record to an opportunity (or Deal) record. If you are using custom fields, then just ensure that the data type...

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

Using a HTML form and PHP to upload a filehttp://mail.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 browsers. If you need more, you need to edit your PHP.ini file. 4. Test your PHP file can process the data Add the following code to the receiving PHP file: echo "Upload: " . $_FILES["uploaded_file"]["name"] . " "; echo "Type: "....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 for a bit. Their solution only permanently sets the default sort order to WEBLINK TITLE in order from A to Z. The below code with my modifications maintains the functionality for the user to change the sort order by clicking on the column titles. The...

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

Joes Revolver Map (JRM)http://mail.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 website admin panel Install this module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you got from revolvermaps.com into the module parameter. Important Note: The ID it installs with is for my demo site. If you...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

ReCaptcha disappears from Joomla 2.5 Registrationhttp://mail.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find the...

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

Sort an associative array by values in Javascripthttp://mail.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...

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

Zoho Templates - Font size is inexplicably tinyhttp://mail.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 Here are two screenshots to demonstrate the issue: Screenshot #1: This screenshot is of the PDF preview of my HTML code where I've had to set the font size to 46pt throughout the template: Screenshot #2: This screenshot is of the PDF preview of my HTML...

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

Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

31 January 2020 year starts from January, simply divide by 3... How? I'm showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames =...

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

Zoho CRM/Creator - Common Errors & Gotchashttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 ZohoCRM.settings.ALL ZohoCRM.users.ALL or to be safe ZohoCRM.modules.ALL ZohoCRM.settings.READ ZohoCRM.users.READ Problem: Code 37: The HTTP method PUT is not allowed for the requested resource This was an issue where I was trying to push a Zoho Creator...

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

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

11 March 2022 Document (the file upload field) Downloaded (a picklist with the options "Downloaded" and "Pending Upload") Here's the code for the parent form to download the attachments and upload them to the Creator "Document" form: // // get attachments...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttp://mail.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why?...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://mail.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 A quick article with the code to download image attachments from a Zoho Ticket and then to upload the attachment to Zoho Analytics. Why? First of all, we couldn't find how to sync attachments from ZohoDesk to ZohoAnalytics using the integration. Other...

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

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

14 May 2024 A workflow notify by email didn't give the option to remind daily... only weekly or monthly. Spent a while trying not to use code but here we are. Code is our friend. How? So we'll run a workflow that triggers on the creation of a lead and runs a...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 the part of adding the various field placeholders onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent to...

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

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

04 November 2024 app for a webhook response, would result in the end customer suddenly downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution:...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 cd to the new project name To give permissions to write sudo chmod -R 777 . open the newly created widget.html file in your code editor add the code as per the below generic script when done, save 'widget.html' then return to terminal and type zet...

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

Zoho Deluge: Convert Map to URL Parametershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! What follows is the code I'm using to convert this: v_Endpoint =...

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

Zoho Creator: isBlank and isNull: Before or After?http://mail.joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 A really quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {......

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

Write a Calendar in Autohotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the...

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

SSRS Zero Paddinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 as "-201". As I wanted a link so that the user can just click on this link and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *