Search - Joel Lipman .Com

1. COVID-19: Working from Home: / Articles /; Ergonomic adjective "relating to or designed for efficiency and comfort in the working environment." So it's pretty important not to be slouching over the coffee table for hours or days on end. I ...; Created on 05 July 2020
2. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; What? An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing ...; Created on 07 April 2022
3. 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
4. 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
5. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first time ...; Created on 11 February 2022
6. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
7. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... If that were the case, it would have been a 5 minute job. Instead, it's turned into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format r_CallDetails ...; Created on 18 November 2021
8. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... in a subform called "Mondays" then to click a button which copies it to the remaining working days. How? So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. ...; Created on 17 November 2021
9. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues around tweaking the function and getting it to understand basic mapping and attachments. ...; Created on 21 October 2021
10. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... // deprecated // use inventory_levels m_Variant.put("inventory_policy","deny"); m_Variant.put("inventory_management","shopify"); m_Variant.put("inventoryItem",); // not working // use inventory_items l_Variants.add(m_Variant); m_Product.put("variants",l_Variants); // / ...; Created on 17 October 2021
11. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... The advantage of working in a team of Zoho developers, is that "two heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by to the query which works ...; Created on 08 October 2021
12. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ...; Created on 21 September 2021
13. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData ...; Created on 26 August 2021
14. 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
15. 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
16. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the ...; Created on 30 April 2021
17. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... { "code": 7115, "message": { "From": "Sorry, this record cannot be edited." } }, "status": 1 } } [The working solution] I'll cut to the quick solution, which wa ...; Created on 10 December 2020
18. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... usually have 3: .joellipman.com (used in verification), .joellipman.com and www..joellipman.com (for the subdomain). I have had this working with the 2 CNAME records though. Some providers say this ...; Created on 17 November 2020
19. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company ...; Created on 28 August 2020
20. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... Playing a game full screen ms-settings:quietmomentsgame TruePlay ms-settings:gaming-trueplay Xbox Networking ms-settings:gaming-xboxnetworking Mixed Reality (requires Mixed Reality Portal app) ...; Created on 30 July 2020