Assuming code is required, the following 253 results were found.
-
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" to "Male", "Prof" to "Professor"). Why? Our extract phase in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
that you have the freedom to distribute copies of free software (and charge for them if you wish), that you receive source code or can get it if you want it, that you can change the software or use pieces of it in new free programs, and that you know...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
because in my opinion, the simplest way to start using COM is to learn some basic JavaScript, and then "translate" that code to use with COM in AHK. COM - (Component Object Model) All you really need to know about COM for this tutorial is that Internet...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
XET from the menu system and you should be presented with a cleared/new record Complete the form noting the name of your XET Code and then selecting the appropriate dictionary and entity; here we are using SRS as the dictionary and CAP as the entity....
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
mode, go to "Settings" Under "Users and Control" click on "Publish" On the same row as your report, click on "Get embed Code" (ensure this report is published) Get the Permalink and copy and paste this into a new browser window/tab Right-click on one of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article on how to use remove() on a map variable as well as a snippet of code to copy tags from a contact to a deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
address on the CRM record 'pulls through'. Sending the address in the same request however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
attempting: { "response": { "message": "Error occurred", "uri": "/api/forms/json/P_ApplyLeave/updateRecord", "errors": { "code": 7013, "message": "Field name 'ApprovalStatus' is invalid " }, "status": 1 } } [Warning: Another red herring ahead] We tried...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. Why? At time of print, Zoho had recently introduced the ability to have custom fields in your line items,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
this from happening: First - Off: The one workflow to rule them all In the first instance, we don't want large amounts of code to be copied and pasted for each field, especially if they're doing the same thing for example displaying a preview in a notes...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets as these might answer your question to begin with and then we'll do the easy bit on how you set this up in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
languages, I often need to write the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article on some code added to a button in ZohoBooks off the invoice module to initiate your Stripe terminal to take a payment. Why? Just to make it easy on the staff at a counter or on the phone. They bring up the invoie in ZohoBooks, click on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response. Getting to the development-side Login to ZohoCRM as a super-admin Go to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making some minor changes to the MediaWiki LocalSettings.php...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *