Search - Joel Lipman .Com

21. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... of the fields is changed Add an eTag field: Will hold a 32 hexadecimal character string / a hash of the fields to monitor Add the if statement to compare etags on your main workflow. Other fields ...; Created on 19 September 2021
22. 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
23. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
24. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... ("code" is 6-character code obtained in step 1c above) If allowed set the TTL (time to live) to 300 Set the CNAME value to creator.cs.zohohost.com or creator.cs.zohohost.eu (depending on if you access ...; Created on 17 November 2020
25. 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
26. 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
27. 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
28. 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
29. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... for Inventory OAuth 2.0 Connection - Custom Service - on account server COM https://deluge.zoho.com/delugeauth/callback Problem: Split a string with the escape character/backslash character Trying ...; Created on 06 February 2020
30. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)"; v_FormattedString ...; Created on 31 May 2019
31. CSS Add Text to Breadcrumb Link with a Transition: / Cascading Stylesheets /; ... last snippet is completely optional if you want to prefix the character » to your breadcrumbs. Unfortunately, this only deals with the opacity transition as the width transition is not a smooth one. ...; Created on 18 May 2019
32. 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
33. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't a letter, a number or an underscore. How? Suppose the following exists as a MySQL ...; Created on 06 May 2019
34. Zoho Deluge - MD5 function: / Zoho /; ... be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a multiline but this would defeat the objective of an Etag). How? Well I was going to documen ...; Created on 19 November 2018
35. Display a thumbnail of a Google Drive video: / Google /; What? A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which ...; Created on 13 November 2018
36. Zoho Deluge - Get English Ordinal: / Zoho /; ... = Ordinal_Map.get(My_Date_Field.toString("d")); } Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar ...; Created on 08 November 2018
37. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... "id": "1srXLU-lotsofalphanumericcharacters_", "name": "my_video.mp4", "mimeType": "video/mp4" } Additional: Why not? Let's add a description and some security where we disable download, sharin ...; Created on 29 October 2018
38. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it ...; Created on 02 August 2016
39. Trim values along with the tab: / MySQL /; What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. ...; Created on 13 June 2016
40. Joes Word Cloud (JWC) Download: / Downloads /; ... fix "&". - Double-check that unicode characters work in exclusion list. (they do)- Date Uploaded: Mon, 8th Aug 2011 1.6.6 - Bug Fix: "Case-sensitive=No" now checks that word in different case is not ...; Created on 07 September 2015