Search - Joel Lipman .Com

1. 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
2. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; What? A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho ...; Created on 21 September 2021
3. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... void fn_Leads_FollowUpNonConverted(Int p_LeadID) Label: Fn - Leads - Follow Up Non Converted Lead Trigger: Triggered 24 hours after a lead is created. Purpose: Follow up when ...; Created on 14 May 2024
4. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... of "Schedule - Shopify Webhooks" It has the code standalone.fn_Shopify_RestoreWebhook(); Starts ASAP; with a frequency of Hourly (run every 2 hours); and never ends. Save and done. Error(s ...; Created on 22 April 2024
5. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... include:spf.mycompany.com include:spf.protection.outlook.com include:one.zoho.eu ~all Check using the toolkit: Some registrars will say this can take between 24 to 72 hours to propagate. In our ...; Created on 04 May 2023
6. ZohoCRM: Import Attachments: / Zoho /; ... := "Success_" v_ProcessID v_FileName_Prep := "Prep_" v_ProcessID ; to be set on setup (leave blank) v_TotalHours := 0 v_YourProfile := "" v_YourEmail := "" v_YourBrowser := "" v_YourName := ...; Created on 16 January 2023
7. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So ...; Created on 07 April 2022
8. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... one way, in other words, listings on eBay get downloaded to Zoho Inventory but not vice-versa. Then there's an added delay of 4 hours. Then item specifics in eBay's listings don't get parsed into custom ...; 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 Analytics: Setup DataSource via FTP Connection: / Zoho /; ... Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: ...; Created on 12 January 2022
11. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2 schedules: one that runs on even hours and one ...; Created on 10 January 2022
12. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... = "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; // // calculate GMT v_CustomerPlusMinus = v_CustomerOffset.subString(0,1); v_CustomerHours = v_CustomerOffset.subString(1,3).toLong(); v_CustomerMinutes ...; Created on 07 December 2021
13. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... time in our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run every ...; Created on 02 December 2021
14. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... Billable"); v_WorkNotes = ifnull(input.Work_Notes,""); v_TaskOrIssue = if(input.Type == "Task", "tasks", "bugs"); // // eval v_HoursDecimal = (v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 ...; Created on 30 April 2021
15. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... will take between 24-48 hours but I have often found that after a few hours, the effects have been propagated. A test I like to do is open the command-line in MS-Windows or the terminal on MacOS, and ...; Created on 17 November 2020
16. 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
17. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... unit to display Hours : Minutes : Seconds. We could have tried out some cool new DLL files for MS Windows 10 but we needed something lightweight that doesn't require any extra files and that could ...; Created on 07 August 2020
18. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... Display (Orientation) ms-settings:screenrotation Duplicating my display ms-settings:quietmomentspresentation During these hours ms-settings:quietmomentsscheduled Encryption ms-settings:deviceencryption ...; Created on 30 July 2020
19. 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
20. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; ... DuckDuckGo (can't say for Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started ...; Created on 10 March 2020