Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... and then I'll include the code to query the shipment status based on a tracking number. Becoming a DHL Developer Browse to https://developer.dhl.com/user/register to Signup Complete the form with ...; Created on 21 March 2023
13. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response. ...; Created on 06 March 2023
14. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows ...; Created on 01 March 2023
15. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...; Created on 01 March 2023
16. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
17. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... you know the code to remove this field, then you know what I mean. In Workflow mode: add a workflow to the form whenever it is created or edited, on load of the form; I call mine "OnLoad". For Deluge ...; Created on 28 February 2023
18. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth ...; Created on 20 February 2023
19. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; What? A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article ...; Created on 13 February 2023
20. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... type the deluge code), there will be a "Connections" in the top grey bar that you should click on and create a connection with the scopes that you want (I select nearly all of them), and I'm going to call ...; Created on 08 February 2023