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 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... AutoHotkey releases. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. ; ...; Created on 08 July 2020
17. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... when listview row is double-clicked to open Chrome Browser with selected Profile. #NoEnv #Warn SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance force ; -------------------------------------------------------------------------------------- ; ...; Created on 07 January 2020
18. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; What? A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected ...; Created on 28 June 2019
19. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl( ...; Created on 03 June 2019
20. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... yields Joe\'s \"Amazing\" Skill \& \ Grunt Replace new lines in returned JSON (invalid in Zoho): v_MyString = "{"MyKey":"MyValue "}"; // the long way (and cos the regex for this isn't working) v_FormattedString ...; Created on 31 May 2019