Assuming used is required, the following 202 results were found.
-
Function: Map fn_GetSystemValues() Trigger: Snippet to be used at beginning of code to get dynamic maps of system values Purpose: Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts Inputs: - Outputs: - Date Created: 2021-09-24 (oel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
it is recommended you do as it did work if the criteria were encoded... The criteria is in the same syntax format as the one used in the Search API call. Code-wise using the same criteria variable for both calls might offer some consistency. Notes on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Zoho Creator. Having this example for future use might save me some time. The following is the early version of a JS widget used for a customer and before I added all the layers of complexity, I want to have here an example that demonstrates a basic...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
v_ThisTimeZone) Incorrect Created By: this is because the system manager who initially set up CRM is used by default. By creating a connection as a system user with the necessary scopes to this CRM instance, untick use credentials of logged-in user, and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a grain of salt), the scope should be ZohoInventory.settings.READ. I have another connection called "zinventory" which is used here to retrieve the item/product record. // // initialize m_Blank = Map(); // // evaluate v_BooksOrgID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
source for Zoho Analytics. Why? We're assisting a client implement Zoho People as their new HR solution. Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data is incorrect in Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
Give it a name, set the schedule and then wait for it to finish building the table. If you want the Zoho SQL (Ansi-SQL?) used to link the purchase order items with the sales order items based on the custom lookup field: SELECT po."Purchase Order ID" AS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to use ready for uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section here where I demonstrate how to upload photos to be hosted by the Zoho Analytics app....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... } isBlank() can be used to check if the string only contains blanks or if a value is null... How? Consider the following test function: void...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
necessary in the end, I can use shortcode for getting the tag. Note that on a fresh CRM instance where no tags have been used previously, I would use the code above to maintain tag colors. Here's the shortened version where the system chooses the color...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
identifier of the eBay user notification.data.eiasToken this string is the eBay user's EIAS token; another identifier used for an eBay user ******************************************************************************* */ m_Payload =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
An article on a client script used in CRM which is a working example of rewriting a subform (line items of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
p_DealID) Label: Fn - Deals - Retrieve Pipeline Trigger: Standalone / REST API Purpose: Function used by a client script to retrieve the pipeline given a deal record id Inputs: Deal Record ID Outputs: the value of the pipeline Date Created: 2025-05-06...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a JWT which was an absolute waste of time with regards to what I was attempting to do. How? Let me show you how we used to connect and then what the new code will be. The preamble to both of these is how to get the values to include in the invokeURL...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
[ url: v_Endpoint2 type: POST parameters: m_Params headers: m_Header connection: "zanalytics" ]; info r_AddRow; } } // // used while debugging / remove once in production if(v_CountTotal >= 3) { break; } } return "Processed " + v_CountTotal + "...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Then I'll write the SQL to sum up the responses per page per survey attempt. Finally, I'll see if analytics can be used to generate the radar chart. ZohoSurveys - Individual Responses Query (if using CRM to send surveys) If using the CRM integration,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
string standalone.fn_Xero_MapTaxRates() Label: Fn - Xero - Map Tax Rates Trigger: Standalone / On-Demand Purpose: Function used to map Xero tax rates to Zoho ones Inputs: - Outputs: - Date Created: 2025-10-13 (Ascent Business - Joel Lipman) - Initial...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to do this by title in ascending order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution only...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
4. Disable Authentication - AEC Access 5. Enable Authentication - Joomla 6. Re-enable any other authentication plugin you used to use. 7. Disable System - AEC Routing 8. Disable System - AEC ErrorHandling 9. Extensions > Install/Uninstall > Plugins 10....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
you find all your forms need extra plugins and captchas (such as JezRecaptcha), then the website security isn't amazing. I used to have Captcha on my K2 by Joomlaworks but if you did the sound version, it didn't work properly. I found that sometimes the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *