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

28 March 2023 to create and declare the subform before having specified any record to insert it into. 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...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttp://mail.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 > 0) { // // A quick CSV line f_TestFile = "Test 1,Test 2,Test 3".toFile("test.csv"); f_TestFile.setParamName("file"); // // found if you open the report properties and select rename from the vertical ellipsis icon in the top right v_ReportLinkName =...

• 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 applied for my client, but I'm awaiting feedback (UAT = User Acceptance Testing) to ensure this behaves as expected. So I found another function was being run when a contact record is created and I appended this snippet of code to the end of it. Note...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 the invokeUrl wants its parameters changed using .toString()... sometimes it doesn't, as it did in this case. EXTRA_KEY_FOUND_IN_JSON {"errorCode":8542,"errorMessage":"Unknown JSON attribute(s) found in the parameter CONFIG."}: This was because I was...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 brief (whether it's the right tool for the job is a different issue), let us synchronize Zoho Surveys into Zoho Analytics. I found I need to edit the setup of the sync every time a new survey is added... but at least it lets me synchronize every hour....

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

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

09 October 2025 cancelled nor expired if (a_QuotedSalesOrders[i].Status !== "Cancelled" && a_QuotedSalesOrders[i].Status !== "Expired") { // found one so let's bail v_FirstSalesOrderID = a_QuotedSalesOrders[i].id; break; } } // if not null (was found) then let's assign...

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

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

09 October 2025 */ // // init v_OutputMessage = "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 20; b_Debug = false; // // Xero Invoice Statuses...

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

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

13 October 2025 */ // // init v_OutputMessage = "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 1; b_Debug = false; // // Login to Xero >...

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

Select unique values in Microsoft Excel columnhttp://mail.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 record var v_ContactEmail = r_ContactDetails.Email; // check it isn't blank if (v_ContactEmail != "") { // display the found value in the field called "Vendor Contact Email" ZDK.Page.getField("Vendor_Contact_Email").setValue(v_ContactEmail); } } catch...

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

GDPR Privacy Policyhttp://mail.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 incomplete, please write to or email us as soon as possible at the above address. We will promptly correct any information found to be incorrect.

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Terms & Conditionshttp://mail.joellipman.com/static-items/terms-conditions.html

30 May 2009 or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttp://mail.joellipman.com/static-items/privacy-policy.html

30 May 2009 incomplete, please write to or email us as soon as possible, at the above address. We will promptly correct any information found to be incorrect.

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

Applying a button and centering it in the RocketTheme Affinity templatehttp://mail.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot more to do than just that. Instructions Open the templates/rt_affinity_j15/index.php Look at the last...

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

Using MetaMod to hide buttons from logged in usershttp://mail.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 It's been difficult to find an easy solution to hide menu items from registered users. Finally, I found a solution that works 100% for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 then check your logs to see if anyone has been trying to hack your website. There are a number of components I have found that even with captcha features, still get hacked with viagra emails and what have you (eg. JoomlaBook). If you don't want to go...

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

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

15 November 2009 order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution only permanently sets the default sort...

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

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

27 January 2010 " S " htmlText:=htmlText " S " htmlText:=htmlText " " htmlText:=htmlText "" ; GET NUMBER OF DAYS THIS MONTH ; Haven't found anyone who calculates how many days there are in a month so this is a crude solution ; This checks if this year is a leap year...

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

Anti-Spam override for all submitted datahttp://mail.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 isn't amazing. I used to have Captcha on my K2 by Joomlaworks but if you did the sound version, it didn't work properly. I found that sometimes the captcha wouldn't even match what you typed and what it displayed!!! I have written this article to be...

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

Running Internet Explorer 6, 7, 8 as standaloneshttp://mail.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Explorer). Scan for threats Run "C:\Program Files\Internet Exploreriexplore.exe" for IE7 Run the "iexplore.exe" program found in the IE6 download to run IE6. It will return v7 on the "about" dialog but I felt this was because I already had IE7...

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