Search - Joel Lipman .Com

1. Zoho Deluge: Proper Case for Names: / Zoho /; What? This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the ...; Created on 13 July 2023
2. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; What? There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with ...; Created on 12 July 2023
3. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; What? A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing ...; Created on 01 September 2021
4. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What ...; Created on 08 July 2020
5. Zoho Deluge - Get Full Day Name: / Zoho /; What? This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters ...; Created on 08 November 2018
6. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add ...; Created on 24 September 2015
7. SITS: Export field code and name: / Extensible Markup Language /; ... &GCOD_NAME.COD.SRS England -- What I want: export format to get multiple values -- &G[COD.SRS:•|•] 5826|England How? You can see it in the code above but I'll give the run through using the ...; Created on 12 August 2014
8. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; Applies to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. ...; Created on 09 August 2014
9. PHP: First name and Initial of Surname: / Personal Home Page /; What? A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- ...; Created on 27 March 2014
10. Add the website name to the page title in Joomla!: / Joomla /; ... seems to come out with a new version. If you have installed Joomla 2.5, this is now a setting in the global configuration... The only problem is that your landing page becomes "HOME - SITENAME.COM" which ...; Created on 06 September 2009
11. ZohoCRM & ZohoWriter: Generate Rich Email Signatures in CRM: / Zoho /; ... = ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url ...; Created on 05 December 2023
12. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... #3 of the Note on this page), like Campaign_Name:equals:CRM, the response will contain only those records whose Campaign_Name is "CRM" and not records with "Best CRM" or "Latest CRM" in their Campaign_Name ...; Created on 14 November 2023
13. Zoho Books: System Values Maps: / Zoho /; ... = Map(); if(!isnull(r_ChartOfAccountsUK.get("chartofaccounts"))) { for each m_NomAccount in r_ChartOfAccountsUK.get("chartofaccounts") { m_NominalAccountsUK.put(m_NomAccount.get("account_name"),m_NomAccount.get("account_id")); } } info ...; Created on 07 November 2023
14. Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Department: / Zoho /; ... a system administrator > Go to Setup > Client Script Clicking on the "New Script" button in the top right. For this demo, we give it the name "On Deal Creation" and in the description I've commented that ...; Created on 16 October 2023
15. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the ...; Created on 04 October 2023
16. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... build attachment request m_Attachment = Map(); m_Attachment.put("paramName", "attachment"); m_Attachment.put("content", f_BillsExport); // // this variable name is in plural, but as a custom function ...; Created on 02 October 2023
17. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID ...; Created on 18 September 2023
18. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... from a public domain, no user wall. The key here which the official documentation is missing is the .setParamName() but for those who have spent time to find this function, they'll already know this. ...; Created on 20 July 2023
19. Zoho CRM: Change System Field Length: / Zoho /; ... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...; Created on 19 June 2023
20. Zoho Finance Suite Schedule: PATTERN NOT MATCHED: / Zoho /; ... Unless you can monitor when these type of schedules are failing, you won't see this error until you go in and try to save it again. How? The super quick answer is remove any spaces from the name ...; Created on 12 June 2023