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. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect: https://zohomail.tools/#runChecks Source(s): ZohoCRM: ...; Created on 04 May 2023
3. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; What? A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing ...; Created on 28 March 2023
4. 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
5. ZohoCRM: Import Attachments: / Zoho /; ... the reverse process, the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" ...; Created on 16 January 2023
6. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; What? An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and ...; Created on 17 August 2022
7. 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
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. 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
10. 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
11. 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
12. 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
13. 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
14. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... " + v_Tomorrow.toString("MMMM") + " "; v_Day3_Header = "" + v_NextDay.toString("d") + v_Day3_Ordinal + " " + v_NextDay.toString("EEEE") + " " + v_NextDay.toString("MMMM") + " "; Generate a list of workin ...; Created on 02 November 2021
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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