Search - Joel Lipman .Com

1. OpenCart: / Category /; Created on 05 March 2020
2. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; What? A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article ...; Created on 13 February 2023
3. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; What? This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module ...; Created on 08 February 2023
4. MS Excel - Open CSV with Long Numbers: / Excel /; What? This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ...; Created on 23 July 2019
5. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... another screen of app icons. The same can be done to the desktop versions with open applications instead of just their icons. Why? MS Windows 10 has made a major step but when you close down your ...; Created on 18 July 2019
6. SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issue: / SQL Server Integration Services /; ... was for me: Open Start > All Programs > SQL Server 2012 (or your latest) Expand "Configuration Tools" and open "Sql Server Configuration Mnaager". Right-click on "SQL Server Integration Services 10.0" ...; Created on 09 June 2014
7. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution: 1 is that ...; Created on 04 November 2024
8. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... the name "Joels Image Library". I think I closed it and reopened it but now I want a 2nd column. So I click on the "Add" button and select "Add Column" > I called the column "ZohoAnalytics Image URL" and ...; Created on 25 July 2024
9. Zoho Projects: Get All Events: / Zoho /; ... the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used ZohoCRM then this is obvious; if you haven't then it may be difficult to work this out. ...; Created on 22 July 2024
10. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is ...; Created on 07 May 2024
11. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a ...; Created on 25 March 2024
12. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... ie "Extra Confidential" has been ticked if (b_ContactConfidential) { // prompt with a confirmation box var b_Proceed = ZDK.Client.showConfirmation('Do you want to open the mailer ...; Created on 06 February 2024
13. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger downloading. File is deleted from attachments ...; Created on 02 October 2023
14. Zoho Deluge: Proper Case for Names: / Zoho /; What? This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the ...; Created on 13 July 2023
15. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait ...; Created on 03 July 2023
16. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... "ITEM CREATE RESPONSE FOR " + v_ItemID; info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to hav ...; Created on 04 May 2023
17. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
18. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... != null) { // // let's format a little as the business days are given in the correct order m_ShiftRow = Map(); m_ShiftRow.put("open","00:00"); m_ShiftRow.put("close","00:00"); m_ShiftBuildU ...; Created on 28 March 2023
19. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; What? Following on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM. Why? Because it is a serious improvement ...; Created on 06 March 2023
20. ZohoCRM: Import Attachments: / Zoho /; ... "" v_Message := "" v_YourDate := A_Year "-" A_MM "-" A_DD b_KeepOpen := false v_RunFolder := A_ScriptDir "\Run_" v_YourDate "_" A_Hour "-" A_Min ; -------------------------------------------------------------------------------------- ; ...; Created on 16 January 2023