What?
This is a very quick article with a code snippet on how I added to a multi-lookup field.
Why?
Using a multi-line or text is possibly a quicker solution and when using a desktop interface, ...
What?
A really quick article for anyone who got stumped by the same issue: How to send multiple invoices to Xero in one API call?
Why?
Our use-case is in Zoho Deluge which couldn't generate more ...
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 ...
What?
This is an article documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing ...
What?
The aim of this article is to document how you can display a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through ...
What?
A very quick article on how to push a multi-select picklist from CRM to Creator.
Why?
We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module ...
Applies to:
Microsoft Windows 10
AutoHotkey 1.1.30
What?
Yay for Microsoft Windows 10 in joining the rest of the Operating Systems in implementing multiple desktops. So if you have a Mac or Linux ...
... item and filtering the options available for selection.
Why?
This was for a multi lookup with staff as the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave ...
Applies to:
Microsoft Windows 7 Professional
Ms-DOS Command Prompt (6.1.7601)
What?
A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. ...
What?
A quick article on an alternative to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" ...
What?
This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate ...
Applies to
Transact-SQL (T-SQL)
What?
This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table.
Why?
I have a table that ...
What?
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 ...
... or different columns) with equals and starts_with conditions.
The only operator that is supported for encrypted fields is equals.
When you use "equals" for multiple conditions, and if one of your conditions ...
... that for the below, the Top Level Domain (or Zoho DataCenter) is EU rather than the COM. I have a connection called "zbooks" and the v_BooksOrgID is the ID of the instance in ZohoBooks; so for multiple ...
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? ...
... "Role" with the options: "user", "assistant", "system".
Add a file upload field called "Big Data"
Add a single line field called "Title" (used as a multi-line cannot be used in the listview).
Add ...
... a split for any multi-line item orders:
//
// declare variables to store order details in a JSON or ZohoDeluge Map format
m_Response = Map();
l_JsonOrders = List();
//
// loop through orders in ...
... list of pages to loop through (note: issues with multiple pages, do 1 at a time)
l_Pages = ;
v_PerPage = 200;
for each v_Page in l_Pages
{
v_CountTotal = 0;
v_CountProcessed = 0;
v_FromIndex ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.