Assuming written is required, the following 30 results were found.
-
This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this article because I keep forgetting on how to do this. I have a specific order of steps on how I do this, you may find other...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
integration field, it will return an error Unable to update the value to r_RecordDetails.Account. Line:(442) How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you want to assign it to an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for The following script is what I use to pass the record ID to a CRM function called fn_Accounts_CreditSafe. It was partly written by referring to documentation and using CoPilot or OpenAI ChatGPT for parsing the return value of the function (note that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Splatter Logohttps://joellipman.com/graphic-design/splatter-logo.html
I saw this article and rather than bookmark it I thought I could just have it here for easy reference. It was written for Photoshop but I use Paint Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
operators in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the statement: If...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName`...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF