Search - Joel Lipman .Com

1. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after ...; Created on 18 September 2023
2. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... should get the following error: Please ensure that the shipping_address has less than 100 characters. How? If you get the above error, the community forums will advise you to get the ID of the ...; Created on 22 September 2021
3. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other ...; Created on 03 June 2021
4. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you ...; Created on 28 August 2020
5. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = ...; Created on 25 March 2019
6. Convert foreign characters to English alphabet: / MySQL /; What? A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I' ...; Created on 13 June 2016
7. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; Applies to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without ...; Created on 25 January 2016
8. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it ...; Created on 01 August 2012
9. UTF8 Unicode PHP MySQL for International Characters: / Personal Home Page /; This is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters ...; Created on 22 October 2010
10. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value ...; Created on 11 October 2024
11. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... ," ").getPrefix("+").toString(v_TimeFormat),"-"); // // generate XML related list response // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedList ...; Created on 06 August 2024
12. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with ...; Created on 25 July 2024
13. Zoho CRM: Change System Field Length: / Zoho /; ... out-of-the-box differ in length so they do not list the postal code on the deal record to be listed in the "Lead Conversion Mapping" page. In the Leads module, the Zip field is 30 characters; in the ...; Created on 19 June 2023
14. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... multi-line field called "Content" and change the properties on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page where you ente ...; Created on 06 March 2023
15. ZohoCRM: Import Attachments: / Zoho /; ... the filename appended. Because of MS Windows 11 limitations (any MS OS really), you need to ensure that long hyphens (#151) and some other funny characters are replaced out as the OS won't allow the file ...; Created on 16 January 2023
16. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... + v_QuoteRef + ""; // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML = v_RelatedListXML + "" + v_DateTill ...; Created on 30 July 2021
17. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... the double-quotes and no funny characters). It will initialize a project in a folder called something like “/Users//joels_awesome_app” It will then initialize some NPM dependencies and it will ask ...; Created on 24 October 2020
18. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... is used for but I enter the same name in lowercase and replacing special characters with an underscore. eg. "the_joel_lipman_app" Authentication Type: set this to "oauth2" Param Type: set this to "Header" ...; Created on 12 August 2020
19. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... are sending are not in the right format. : The attachment parameter is populated with the file content instead of the internal file name. : The doc parameter contains special characters. Improper ...; Created on 15 May 2020
20. MySQL: Count occurrences of words in a column: / MySQL /; ... have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I ...; Created on 12 March 2020