Assuming here is required, the following 180 results were found.
-
field type so our record can have more than 1 file attached to it. the CRM.attachFile command Okay as a first example, there is a problem here, you asked for Books and this next bit shows how to attach it to a CRM record. This works in the scenario...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
blue AutoHotkey_L: black AHK Basic: green Some other tutorials that helped me out, and inspired this tutorial can be found here: - COM Tutorial by tank - Study the basics from this; I will not be covering them. - W3Schools - Many links listed below will...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
replying "why would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
an article to remind me how I did this for a customer and images help visualize the health of the system. Why? The use-case here is to build a system which monitors a Zoho App for when records were last modified and if a synchronization process starts...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
on Advanced Click on New... For the Action type what ever you want the context menu to display, I use Command prompt from here For the Application value type c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
some, so the below details on how you can get Xero to tell Zoho when a contact or invoice has been updated immediately. How? Here's an overview of how we achieve this: Set up a Zoho CRM function to receive the webhook. Setup a webhook in Xero. [Optional...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to the lead record owner but to no avail. An assignment rule wouldn't work in this case as it had to be the lead owner (there is no owner at assignment rule stage). A workflow email notification doesn't do the popup on the CRM as well. A workflow notify...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article taken from https://goodereader.com/blog/kindle/here-is-how-you-can-read-pdf-files-on-the-amazon-kindle which I wanted to take note of as it is a process that worked at time of print (6 June 2022) and I wanted to make sure it didn't...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
function invokeURL rather than the usual shortcode of zoho.crm.updateRecord() or zoho.crm.createRecord(). How? This is somewhere in the official documentation but here's the bits that I need: Updating a record with PUT (note that id needs passed for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 where our client wants to query Zoho Recruit via the API but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
How? So taking ideas from my previous article for ZohoCliq; let's use what we know to develop a ZohoZIA for a demo system. There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have that file sat...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
might answer your question to begin with and then we'll do the easy bit on how you set this up in the CRM. I'm using ZohoCRM here despite storing the record in ZohoCreator as the app and data processing is mostly done in ZohoCreator. I could have setup...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
"DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
I've googled and binged but could not find anything that documents how to bring it into line with other search systems. So here we go, hope this helps you. Why? I've created search systems for a plethora of other systems. The aim of this article is to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your site. The...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
This example will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space character and delimiting by a string. The Gist -- What I have Image00001 (Copy).jpg Image00002 (Copy).jpg --...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB