Assuming names is required, the following 57 results were found.
-
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:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Person 2 How? This is a bit of a dirty solution and as long as "id" is not your first column (because "id" can be found in names like "David") it will work. Assume a Map specified in deluge: l_Data = List(); m_Data = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the "Product_Details" key but to the respective module line item API name as per the following screenshot: Following the API names in this example, the Deluge code to send would be something like the following instead (reminder: instead of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= r_CreateSO.get("salesorder").get("salesorder_id"); // v_AddressIndex = 0; m_ShippingAddress = Map(); // set field api names that we will read from and write to l_CrmShippingAddress =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_OutputMessage = ""; r_ContactRecord = zoho.crm.getRecordById("Contacts", p_ContactID); // // get merge field names (for reference) v_TemplateID = "aaaa1111bbbb2222cccc3333dddd4444eeee5"; r_Fields = zoho.writer.getMergeFields(v_TemplateID,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
> Deluge Script: // assuming my sections are called "Tab_Section_1", and so on... [these can be named as you want, the names I've used here are for demo purposes] hide Tab_Section_1; hide Tab_Section_2; hide Tab_Section_3; hide Tab_Section_4; hide...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
straightforward: schedule a call using the GUI then write a test function to check the JSON that is being returned for API names... If that were the case, it would have been a 5 minute job. Instead, it's turned into over an hour of figuring this out. So...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Additional: Daylight Savings Time Just to cover all aspects of this, I create a Zoho Creator form with the timezone names, their offset and their DST offset as well as a boolean to say whether Daylight Savings Time is in effect for this timezone or not....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
FTP details as per your configuration, then click on "Next": Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the data per column (in this example, I highlight the Date column, it then prompted...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Ads Accepted Invited Sent Me Web Invited Accepted Sent Myself Walk-In Accepted Sent Invited The catch is that our campaign names are in data rows not individual columns. How? There may be ways of doing this using the GUI and a "Pivot View" report but I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
(specifically the disabled="disabled" attribute), then press delete/backspace to remove the attribute. Also remove the class names "disableEditProp" and "eventNone". You should get the following: Click on "Done", then on "Save and Close". Go to the Lead...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor * v_PerPage; // // get unique product names (v2 up to 200, v6 up to 10k, v7 up to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// field mapping of quoted items to invoiced items (i console logged out the quote record and used the API names of the invoiced items) // declare new array to store line items for invoice var a_InvoiceLineItems = []; // loop through quoted line items...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and Times to include timezone of Xero instance for accurate time comparisons - Map Xero tax rates to Zoho tax rates (same names in Zoho) - output to console if debug mode enabled More Information:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a database column from another table using a string comparison. Why? I have several 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF