Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 Note that for the below code, only 1 image is accepted at the moment, and the endpoint will depend on your datacenter (eg. COM or EU), and lastly the connection "joel_books" is my connection to ZohoBooks: // // declare ID of item in Zoho Inventory...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 correctly."}: Check your connection string. {"code":"9832","message":"Mandatory parameter(s) missing"}: Not sure why as the only mandatory field I had was the name field. Create a sample record with just the name field (placed at top of request) and...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Midjourney Bot. Just bear in mind that any image in a prompt can be accessed if people work out the link. "Stealth" mode is only available in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 to integrate ChatGPT with ZohoZIA. Why? Previously, I would edit the message handlers of a Cliq Bot I created but it would only understand the questions I have programmed it to and respond with the responses I programmed it to answer with. Any...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 few caveats with this solution: This query needs each campaign name specified to see the results per contact person. You can only use this in another dataset which won't use a sub-query more than 2 levels deep. We're only displaying the maximum value...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 using an API action called "Add_Tags". I'm going to get the tags of the contact record using an invokeurl because shortcode only gives me name and ID; but I want the color code field as well which I only seem to get with an InvokeURL. I'm then going to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 } // unfreeze the GUI ZDK.UI.freeze(false); // return false to prevent saving of record return false; Caveat(s) This only happens if the record is being edited (as in user clicked on "Edit") rather than the inline edits that can be done (eg. user...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 to provide certain information by which you can be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: en-GB

Copyrighthttps://www.joellipman.com/static-items/copyright.html

30 May 2009 other than the following: you may print or download to a local hard disk extracts for your personal and non-commercial use only you may copy the content to individual third parties for their personal use, but only if you acknowledge the website as the...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 as the batter hits the hot pan, tip it around from side to side to get the base evenly coated with batter. It should take only half a minute or so to cook; you can lift the edge with a palette knife to see if it's tinged gold as it should be. Flip the...

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• Language: *

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 website. The website was working fine and I was able resume my click-happy habits. It's a given that in my test, there was only 1 user (me). There are reports though that some people set up websites with NO 3rd-party items whatsoever... For those of you...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution only permanently sets the default sort order to WEBLINK TITLE in order from A to Z. The below code with my modifications maintains...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 to change. Note that I am using the method of hiding the input button and putting an image over it. The code above is only really a solution to if you have one image that you are applying this mouseover effect to. With a bit more time, you could tidy up...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is powerful enough to run these effects...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the middle of writing a component that will...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 at customers computer issues. Note that most of the below were remote support jobs so we weren't there in person and could only see the users screen. Three Webdevelopers phone in to say their computers can't view a website properly "Can someone have a...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 fincs for helping with Native COM Support Sean for creating the COM Standard Library tank for the tutorial listed above, & daonlyfreez tank, sinkfaze, & jaco0646 for reviewing this tutorial Terms - The following terms will be used throughout this...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 to read off the sharepoint list, and it had re-ordered to what I set in the view!!! I don't really understand how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list but needed to list...

• Type: Article
• Author: Joel Lipman
• Category: Infopath
• Language: *