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. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... string is a no go. Set it to an atom time or nice SQL date/time (eg. "yyyy-MM-dd HH:mm:ss") and then apply the function .toTime() Source(s) Zoho CRM v3 Organization API Zoho Community Forums ...; Created on 28 March 2023
3. 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
4. ZohoCRM: Import Attachments: / Zoho /; ... is scatty and the online forums weren't too helpful either. How? In the example below, we are going to document how to import files associated to CRM Contact records. There's first the preparation ...; Created on 16 January 2023
5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... , it may get confused as to where the photo came from and will error when displaying it. I think it will be fine. Source(s) Joel's tired and inefficient brain The non-existent and plethora of foru ...; Created on 31 March 2022
6. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... At time of print, things have moved on and based on the Zoho official forums, this used to be a daunting task. Not anymore at least from what I've seen. You could try adding a subform to Creator ...; Created on 11 March 2022
7. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... Shopify using a Product SKU. Community forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement ...; Created on 12 October 2021
8. 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
9. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums ...; Created on 03 February 2021
10. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... forums that do cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method and then update this article with other methods. Method ...; Created on 14 July 2020
11. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it. ...; Created on 15 May 2020
12. Zoho Deluge - Pad with leading Zeros: / Zoho /; ... So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ...; Created on 07 February 2020
13. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... = v_Name.toLowerCase()]; ... Returns the error: "Expression is not allowed in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums ...; Created on 21 November 2019
14. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So I thought I'd jot ...; Created on 18 July 2019
15. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... Using a snippet from the community forums on how someone shuffled a pack of cards, I came up with a function that will take a list of letters, shuffle the list, and return the first 5 characters. string ...; Created on 09 May 2019
16. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... vendor, etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time ...; Created on 02 February 2019
17. Zoho Deluge - Hide Reset Button on Form: / Zoho /; What? So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here ...; Created on 15 November 2018
18. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; ... the files). Type the followingDELETE rename.bat (removes it from the users computer) Exit the command prompt and we are Done Other Links: DOS - String Manipulation DosTips.com - Forums SS64.com ...; Created on 09 August 2014
19. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... words, you don't have a boss): Method #1 (cowboy fix - not recommended): I would not recommend the following but I found this on the MySQL Forums. Someone solved their issue by resetting (or re-issuing) ...; Created on 28 July 2014
20. Split a row into multiple rows based on a column value: / Transact-SQL /; ... do not account for days off (eg. Saturday / Sunday) How? Adapted from a forum topic: SQLTeam Forums First of all, we want the rows to multiply based on the value of the column: SELECT ...; Created on 23 August 2013