Search - Joel Lipman .Com

1. ZohoCRM: Make either Mobile or Email mandatory: / Zoho /; ... Seems that I can't select the same field in a third layout rule... Easy without coding and probably everyone figures this one out but I thought I'd add it here as I thought it was pretty cool. ...; Created on 03 October 2024
2. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... les order ID" = soi."Sales order ID" Initially we thought we could take the purchase order by simply going through the comments but this only shows Purchase Orders raised from a Sales Order w ...; Created on 09 July 2024
3. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: ...; Created on 25 March 2024
4. Zoho Deluge: Proper Case for Names: / Zoho /; ... to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // ...; Created on 13 July 2023
5. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... it's reached the end of the list as per eBay and not what you might have thought it was. /* Function: fn_GetEbayActiveProducts() Purpose: Queries eBay for all active listings Date ...; Created on 01 March 2023
6. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... in certain cases v_NewLineChar = hextoText("0A"); Thought I needed to add the following but this makes absolutely no difference: f_CSVFile.setCharSet("UTF-8"); f_CSVFile.setFileType("csv"); ...; Created on 01 March 2023
7. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... v_OutputMessage; Update: What is the URL to download the PDF in Zoho Books? Found this today so thought I'd add it to this article: Invoice: https://books.zoho.com/api/v3/invoices/pdf?organization_id=&invoice_ids= ...; Created on 18 August 2022
8. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; What? This is a quick article on how I built my 2022 workstation and got 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article ...; Created on 12 March 2022
9. ZohoCRM: Template: not being able to edit a text box: / Zoho /; What? This is a bit of an odd article with not 100% certainty on what the cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales ...; Created on 25 January 2022
10. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; What? This is an article for training purposes. I'm pretty sure there is official documentation on how to do this but I thought I'd write this article to make it simpler for new developers to follow and ...; Created on 02 September 2021
11. ZohoCRM: Process all records of a module: / Zoho /; ... thought of an alternative that I now use frequently in client systems. How? The gist is that we add a checkbox called "Processed" which will have a datatype Boolean. Our function will then loop ...; Created on 24 August 2021
12. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; What? So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click ...; Created on 06 November 2020
13. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... As someone who's been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very ...; Created on 24 October 2020
14. COVID-19: Working from Home: / Articles /; ... was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my ...; Created on 05 July 2020
15. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; What? Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU ...; Created on 21 November 2019
16. 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
17. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... in width but this is not good for a final solution. I thought maybe there was a setting for the default font size or where I've accidentally zoomed out in the browser... but these were red herrings as ...; Created on 22 February 2019
18. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill ...; Created on 30 November 2018
19. Zoho Inventory Template Issue: First Page is Blank: / Zoho /; What? So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product ...; Created on 15 November 2018
20. Pure JS - Display Time Elapsed & Remaining: / JavaScript /; ... the same, but this is an example that I was coding and found to be one of the most reduced cut down formats I've made. I thought I'd make a note of it to not have to search elsewhere... This example ...; Created on 30 October 2018