Search - Joel Lipman .Com

1. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; What? A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function ...; Created on 04 October 2023
2. 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
3. Zoho Deluge: a HTML Entity Decoder: / Zoho /; 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 " " ...; Created on 27 January 2022
4. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; 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. ...; Created on 15 December 2021
5. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; .joellipman-alt-code-table{ width:100%; max-width:400px; margin:0 auto; border:1px; } .joellipman-alt-code-table td:first-child{ width:40px; } .joellipman-alt-code-table td:nth-child(2){ width:300px; } What? ...; Created on 03 June 2021
6. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; 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? ...; Created on 09 May 2019
7. SITS: Export field code and name: / Extensible Markup Language /; ... 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 just using the parameter ...; Created on 12 August 2014
8. Alternative method of displaying Unicode in Autohotkey GUI: / AutoHotkey /; 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: ...; Created on 29 September 2011
9. Code Troubleshooting Checklist: / Web-Development /; So I've started this 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 ...; Created on 03 June 2011
10. 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 ...; Created on 22 October 2010
11. Language Codes: / Joomla /; ... and narrow-minded to think only English speakers 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) ...; Created on 13 September 2010
12. Creating a Top 10 chart with less code: / Personal Home Page /; ... PHP script to loop through the results of the above query Display the value of column1 and CountOrder The old code would have been: echo '# | Search Term | Count' . "\n"; # ...; Created on 18 February 2010
13. This file contains HTML or script code that may be erroneously interpreted by a web browser: / Hypertext Markup Language /; 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 ...; Created on 08 October 2009
14. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... 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: 1 is that ...; Created on 04 November 2024
15. Zoho Creator: Input Color Picker: / Zoho /; ... Color'] Add another single line field, I'm calling it "RGB Value" [Optional: not required for the functionality of this demo but used in later application when including CSS opacity] Step 1: Cod ...; Created on 14 October 2024
16. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
17. ZohoCRM: Make either Mobile or Email mandatory: / Zoho /; ... but at least one should be. How? We can do this without code and only using ZohoCRM layout rules. Let's take a contact record for demo purposes: If I enter a phone number: If I enter an ...; Created on 03 October 2024
18. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... 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 ...; Created on 06 August 2024
19. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... hitting statement execution limits and rather than proposing an upgrade or add-on to the subscription plan; we wanted some proof using code. How? We're going to use a quick snippet of some code. ...; Created on 31 July 2024
20. Zoho Projects: Get All Events: / Zoho /; ... send to. Here's some code to get the last 50 events: // // *********************************** // get Zoho Projects information v_BaseURL = "https://projectsapi.zoho.com"; v_Heading = ""; // // ...; Created on 22 July 2024