Assuming name is required, and value is required, the following 124 results were found.
-
What? This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting how to do this and it takes about an hour to go through the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
What? This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Applies to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
What? Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? A quick article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
The scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Applies to SITS:Vision v8.7.0 Uniface v9.6.03 Microsoft Windows 7 Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
What? A quick article on how to debug some errors in Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module to another, sometimes you need to manage existing...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
What? A quick article with the code to download image attachments from a Zoho Ticket and then to upload the attachment to Zoho Analytics. Why? First of all, we couldn't find how to sync attachments from ZohoDesk to ZohoAnalytics using the integration....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
What? A quick article on how to display a OK/Cancel popup which I use as a message to the user for debug purposes. Why? It's similar to javascript's message box or confirm box, only Android let's you redesign the dialog. For my purposes I have used an...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
What? A quick article on the SPF & DKIM setup to improve email deliverability from a ZohoApp and methods to check. Why? Not sure how I came across it as most of our customers don't use ZohoMail, but there is a Zoho Toolkit to run some checks on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
What? This is slightly different to my article Zoho Deluge: Get Refresh/Access Token API v2 (Zoho to Zoho service) and different to my Zoho CRM: APIv2 using PHP & cURL (3rd-Party to Zoho), in that this details how to setup a connection to use in an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Update August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
What? An article on a client script used in CRM which is a working example of rewriting a subform (line items of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? This is a quick article I use to list step by step on how to set up a custom domain for a Zoho Creator customer portal. In this example, we are going to use a subdomain of a company which has the domain joellipman.com. Why? This took me a bit of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *