Knowledge base / Since 1999
Advanced
search
Practical notes on CRM development, automation, APIs and everyday IT.
Browse all notes316 results
Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON
... do this to create a Creator record but I'm going to use the shortcode function 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_ ...
ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters
... ess in the same request 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 you have sent the code to ...
Zoho Deluge: a HTML Entity Decoder
What? A very quick article to document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded H ...
Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)
What? An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field ca ...
Windows OS: Alt Codes / Symbols / Special Characters
... ealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using ...
Zoho Deluge - Generate 5 Letter Booking Retrieval Code
What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate ran ...
SITS: Export field code and name
... manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where j ...
Alternative method of displaying Unicode in Autohotkey GUI
Well yes you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgb ...
Code Troubleshooting Checklist
... his list to make sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you suspec ...
Language Codes
... will use Joomla! CMS. The below is for reference only: Language Codes af Afrikaans sq Albanian ar-sa Arabic (Saudi Arabia) ar-iq Arabic (Iraq) ar-eg Arabic (Egypt) ar-ly Arabic (Libya) ar-dz Arabic (Algeria) ar-ma Arabic (Morocco) ar-tn Ar ...
Creating a Top 10 chart with less code
... above query Display the value of column1 and CountOrder The old code would have been: echo '# | Search Term | Count' . "\n"; # create an array of search terms with their frequency count $search_table_results=mysql_query("SELECT DISTINCT co ...
This file contains HTML or script code that may be erroneously interpreted by a web browser
The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making some minor changes to the MediaWiki Local ...