Assuming first is required, the following 215 results were found.
-
the page until all thumbnails have been generated. Switch "STOP Thumbnail Service" to "YES" Logout NB: Thumbnails will first appear blue as the service downloads/queues them. Adding a weblink: Add your Joomla! weblink as per usual Switch "STOP Thumbnail...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to do this on. The part after Zoho is the top level domain (TLD) and will be either .COM, .EU or as per your region. If the first part of your URL says: https://zoho.com/ then use the endpoint https://www.zohoapis.com/crm/v2/coql https://zoho.eu/ then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
accepts a form of records Create a workflow that understands the function parameters Create a function Why are we doing this first? Well when I create a workflow, it will ask me to run a function, the Creator workflow process will then read what...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Create a quote record and include a subform containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can be done all in one go. How? Here's a use case example which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Get the Merged Template ID (hexadecimal) Create the all-in-one button and function to generate and attach the file. First Create a CRM connection I'm going to create a Zoho OAuth connection with open scopes just to get a working example; I can then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
our own stylesheet and overriding certain CSS elements that the vanilla or out-of-the-box Zoho Creator ones provide. First, let's add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the world. US (Except Arizona, Hawaii and US Territories?): DST Start Starts Second Sunday in March at 2:00 DST End Ends First Sunday in November at 2:00 // // Starts Second Sunday in March at 2:00 v_FirstMonthDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
> Manage > Active numbers Note the number you want to use (they have friendly numbers but I use the full number in the first column) Sending a Text/SMS message // // using the account SID you obtained in the steps above v_Account_SID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
line) Starting Date (link name: Starting_Date || type Date) Selected Date (link name: Selected_Date || type Date) The CSS So first of all the value of each radio item will be populated using deluge and what's important to note here is that each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
altogether. I had to break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost of each item purchased; including shipping and tax. The second is to associate these to the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
my previous article for ZohoCliq; let's use what we know to develop a ZohoZIA for a demo system. There are several 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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 error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
using a backslash. Further, you must encode the value. Example: Consider the search term: ((Last_Name:equals:Burns,B)and(First_Name:starts_with:M)) After escaping comma and parenthesis in the value:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a client with about 10k images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
we're going to query it and push it to Zoho Analytics. Find the form link name: Putting this here as it should be what we first did! This is with reference to the Zoho People version 5: Login to Zoho People as an administrator (don't have to be super...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
one may be referred to separately. I want a Zoho Survey when submitted to be parsed by a Zoho CRM REST API function. How? First, I'll go through the steps of setting up the Zoho CRM function, we'll convert it to a REST API function which will give us a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
auto-map. The client script below does the same for invoice as the quote lookup is a custom field on the invoice. How? First, we'll setup a client script specifying what triggers it (on load of the page when creating an invoice) then I'll just put the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
don't get that with Excel but you can still control the data range. How? My example is that I have an excel sheet where the first 10 rows are descriptions to the column, and then I have 38 columns ("A" to "AL"): In the data flow, click on the Excel...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Return (CR) or Line Feeds (LF) are being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special chars rather...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB