Articles - Joel Lipman .Com

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div

: Joel Lipman; Zoho; 22 October 2020; Hits: 5484

What?
So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page).

Why?
This is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in functionality of Zoho Creator and could be seen as a 'Pure CSS' feature. I'm aiming to make a list of capabilities that can be done without loading another framework considering that Zoho Creator has their own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'.

How?
Here are some screenshots to preview what the code below will do, simply copy the code and paste into a Zoho Creator Page.

: Joel Lipman; Zoho; 19 October 2020; Hits: 3973

What?
A very quick article as I couldn't find anything on the WWW to document this error.

Why?
During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error:

copy raw

Expecting ZC_SUBFORM_250 expression found COLLECTION expression

Expecting ZC_SUBFORM_250 expression found COLLECTION expression

Another error you may get when using the deluge script is:

copy raw

LIST value cannot be assigned to 'mySubform'
-- or --
COLLECTION value cannot be assigned to 'mySubform'

LIST value cannot be assigned to 'mySubform'
-- or --
COLLECTION value cannot be assigned to 'mySubform'

copy raw

expecting ZC_SUBFORM_70 expression found COLLECTION expression

expecting ZC_SUBFORM_70 expression found COLLECTION expression

How?
Quite simply the error is because the Creator Deluge syntax I was using to insert subform rows was wrong.

Category: Zoho :: Article: 730

Zoho Deluge: Search Records with Special Characters (COQL)

: Joel Lipman; Zoho; 28 August 2020; Hits: 10371

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 or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you may want to find:

copy raw

Company Name: Father & Sons (Incorporated)
Contact Name: O'Reilly

Company Name: Father & Sons (Incorporated)
Contact Name: O'Reilly

How?
Well I've tried various replace methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters...

Category: Zoho :: Article: 729

: Joel Lipman; Zoho; 12 August 2020; Hits: 9528

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 invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory.

Why?
Setting up a connection avoids the hassle of having to generate access/refresh tokens using OAuth2.0. Usually used with an invokeUrl:

copy raw

response = invokeUrl
[ 
	url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" 
	type: GET
	connection: "joelconnector" 
];

response = invokeUrl
[
url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789"
type: GET
connection: "joelconnector"
];

How?
So in the following example, we are going to setup a connection in Zoho Books on an EU datacenter:

First determine what datacenter your client is using
Register the App
Setup the Connector

Category: Zoho :: Article: 728

: Joel Lipman; AutoHotkey; 07 August 2020; Hits: 4128

Applies To:

Microsoft Windows 7 Professional v6.1.7601 32-bit
AutoHotkey v1.1.33.02

What?
This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS.

Why?
I had an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general.

How?
So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds.

: Joel Lipman; Windows OS; 30 July 2020; Hits: 4185

Applies To:

Microsoft Windows 10 Pro v10.0.18362

What?
This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice.

Why?
I needed a command that can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click...

How?
To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it:

Settings , Command-Line , Microsoft , Windows 10 , Shortcut , AutoHotkey

Zoho Deluge: Get Image Uploaded in Creator Form

: Joel Lipman; Zoho; 14 July 2020; Hits: 15937

What?
So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page.

Why?
There might be different articles out there and discussion forums that do cover this but it takes me so long to find the solution with the right syntax.

How?
So I'm going to start with 1 method and then update this article with other methods.

: Joel Lipman; AutoHotkey; 08 July 2020; Hits: 4602

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 rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name.

What I have

copy raw

EDIT 0_00 0_30 My File 1 00_00 00_30.txt
edIT 0_00 0_31 My File 2 00_00 00_30.txt
eDIT 0_00 0_30 My File 3 00_00 00_31.wav
My File 3.wav
My File 3 - Copy.wav

EDIT 0_00 0_30 My File 1 00_00 00_30.txt
edIT 0_00 0_31 My File 2 00_00 00_30.txt
eDIT 0_00 0_30 My File 3 00_00 00_31.wav
My File 3.wav
My File 3 - Copy.wav

What I want

copy raw

My File 1.txt
My File 2.txt
My File 3 (2).wav
My File 3.wav
My File 3 (3).wav

My File 1.txt
My File 2.txt
My File 3 (2).wav
My File 3.wav
My File 3 (3).wav

How?
So if you copy the following code into an AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files.

Category: AutoHotkey :: Article: 723

: Joel Lipman; Articles; 05 July 2020; Hits: 6626

Ergonomic adjective
"relating to or designed for efficiency and comfort in the working environment."

So it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like...

I made mine into a meme:

Working from Home - Back Breaking : Next Level

Working from Home - Back Breaking : Next Level

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books

: Joel Lipman; Zoho; 15 May 2020; Hits: 9235

What?
This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books.

Why?
Because it took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it.

How?
So the trick is, go over the official documentation, but don't take it as gospel. You only really need the syntax for attaching a document to a Sales Order in Books and the documentation leaves certain bits out. Just getting the syntax right and using the . setParamName is key.

Upload , Download , Attachment , Sales Order , Creator , CRM , Books , Zoho

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String

: Joel Lipman; Zoho; 04 May 2020; Hits: 38665

What?
So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later.

Why?
I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps.

How?
We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it.

Zoho , API Xero , CRM

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator

: Joel Lipman; Zoho; 20 April 2020; Hits: 15045

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 has a multi-select picklist which will use commas to delimit but one of the options has a comma in its value.

copy raw

// What I have in CRM:
{"My_MultiPicklist":["Option1","Options 2, 3"]}

// What Creator understands: FAILS
{"My_MultiPicklist":["["Option1","Options 2, 3"]"]}

// What I have in CRM:
{"My_MultiPicklist":["Option1","Options 2, 3"]}
// What Creator understands: FAILS
{"My_MultiPicklist":["["Option1","Options 2, 3"]"]}

With workaround .toString()

copy raw

// What Creator understands: FAILS
{"My_MultiPicklist":["Option1","Options 2"," 3"]}

// What Creator understands: FAILS
{"My_MultiPicklist":["Option1","Options 2"," 3"]}

How?
So the way to push this value over to Creator is by converting the list to a string... notably comma delimited:

Category: Zoho :: Article: 719

Credit where Credit is Due:

RSS Feed

Related Articles

Joes Revolver Map

Joes Word Cloud

Accreditation

Donate & Support