Search - Joel Lipman .Com

1. Android Background Image Resolutions: / AndroidOS /; ... devices. Configuring drawables for each layout seemed to be the only solution. res/drawable-ldpi 240x320 res/drawable-mdpi 320x480 res/drawable-hdpi 480x800 res/drawable-xhdpi ...; Created on 01 December 2014
2. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; What? A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers ...; Created on 20 March 2023
3. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... in a "Search the web..." task. ChatGPT by OpenAI is viral at the time of print and although the solution below only connects to the OpenAI API, it is not currently connected to ChatGPT. The plus side ...; Created on 13 February 2023
4. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... of Detail 8k resolution Hyper-realistic Intrinsic Details Photo-realistic Precise Details Cameras ...captured using a... Canon EOS R Camera Nikon D850 Type of Filter/Lens ...with a... ...; Created on 11 February 2023
5. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to find a solution. How? Disclaimer ...; Created on 03 November 2022
6. Zoho Creator: Populate a Multi-Lookup: / Zoho /; What? This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, ...; Created on 18 August 2022
7. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other articles ...; Created on 21 June 2022
8. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... wide web that had a working solution. My use-case here is that I have built an eBay integration between Zoho Inventory and... eBay. Out-of-the-box, and at-time-of-print, Zoho Inventory only syncs eBay ...; Created on 31 March 2022
9. Zoho CRM: searchRecords with sorted results: / Zoho /; ... (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods ...; Created on 10 February 2022
10. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... and display 12.5% instead of 12.50%. Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there ...; Created on 08 February 2022
11. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... to say this is a strange issue and an even stranger fix, but I've tested this solution by getting a colleague to refresh the page and check it out as well as the client to go in and confirm the change was ...; Created on 25 January 2022
12. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... (with different v_Webhook_Key). If it still doesn't work then try solution #2: using a third-party server detailed further in this article. Solution #2: Using Third-Party Server If this doesn't work ...; Created on 10 January 2022
13. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... The Solution/Cause So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records ...; Created on 17 November 2021
14. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Well eBay returns URLs to images that have been resized to 400x400 (even with tweak to return 800x800). I wanted a way to upload my image directly to Shopify in 3024x3024 resolution (or the size that ...; Created on 17 October 2021
15. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; What? This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which ...; Created on 19 September 2021
16. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... m_Record.toString(); } Without a regex solution and the replacement back to commas then the above outputs: Actions Do you want to get rid of the annoying escaped double-quotes ...; Created on 26 August 2021
17. ZohoCRM: Process all records of a module: / Zoho /; ... been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have ...; Created on 24 August 2021
18. Xero API: Send Multiple Invoices: / Xero /; ... invoices). Our solution: Send all Zoho invoices in API call to Xero... apparently it can accept up to 60 invoices in one call. How? Crazy simple solution, your JSON needs to have the key "Invoices" ...; Created on 15 August 2021
19. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... how to do this and it takes about an hour to go through the documentation and get a working solution. How? So the article below shows how to do this Zoho CRM and how to do it in Zoho Books... ...; Created on 30 July 2021
20. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... searchRecords function requiring it's 5th parameter which defaults to "not converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The long answer/investigation is getting a JSON response ...; Created on 29 July 2021