Assuming each is required, the following 209 results were found.
-
m_Header.put("Xero-tenant-id",v_TenantID); // // get Xero invoices (page 1 - first 100 - default order is updated date) for each v_Page in l_Pages { m_Params = Map(); m_Params.put("page",v_Page); // // keep the page size low as this function will be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
]; r_OrgTaxes = ifnull(r_TaxRates.get("org_taxes"),Map()); l_TaxRates = ifnull(r_OrgTaxes.get("taxes"),List()); // for each m_TaxRate in l_TaxRates { if(!isNull(m_TaxRate.get("id"))) { m_ZohoTaxRatesByName.put(m_TaxRate.get("name"),m_TaxRate.get("id"));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= ifnull(r_GoalsData.get("response"), Map()); l_GoalRecords = ifnull(m_GoalsResponse.get("result"), List()); for each m_GoalRecord in l_GoalRecords { v_CountTotal = v_CountTotal + 1; l_GoalKeys = m_GoalRecord.keys(); if(l_GoalKeys.size()>0) { v_GoalKey...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid statement...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have already been checked. Some solutions have worked in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
public class ScriptMain : UserComponent { // Method that will be started for each record in your dataflow public override void Input0_ProcessInputRow(Input0Buffer Row) { // C# alternative for VB.Net StrConv uses cultureinfo and threading // See:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
(ticked) records. The example below documents 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
kinds of works, such as semiconductor masks. “The Program” refers to any copyrightable work licensed under this License. Each licensee is addressed as “you”. “Licensees” and “recipients” may be individuals or organizations. To “modify” a work means to...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
matched ID of the Sales Order in CRM r_CreatorForm = myForm[ID == myRecordID]; if(!isnull(r_CreatorForm.Attachments)) { for each row in r_CreatorForm.Attachments { r_AttachFile = zoho.crm.attachFile("CustomModule5004",v_CrmSoID, row.myUpload); } } //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
in November at 2:00 v_LastMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-11-01 02:00:00"); // // loop through each day in a week to get the start and end dates for each v_DayIndex in {0,1,2,3,4,5,6} { v_CheckDateStart =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// // reset and set radio group options clear input.Color_Picker; for each l_ColorRow in l_ColorPalette { for each v_ThisColor in l_ColorRow { input.Color_Picker:ui.add(v_ThisColor); } } Step 2: Replace the text with colored boxes //... // // reset and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Part 2 is dedicated to content migration, the commands are split to do about 5000 articles on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
1000 hits, so thereafter I have to pay every time someone sees that picture through my site; when I could just go to each website and press the print screen key and save this as an image for FREE. I don't get it. So I wrote a program that does exactly...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
[ url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; for each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
url :"https://www.zohoapis.com/books/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; for each m_Tax in r_Taxes.get("taxes") { m_Taxes.put(m_Tax.get("tax_percentage").toString(),m_Tax.get("tax_id")); } info m_Taxes; //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
url :v_Endpoint2 type :GET connection:"zcrm" ]; l_ExistingImagesData = ifnull(r_FetchExistingImages.get("data"),List()); for each m_ExistingImage in l_ExistingImagesData { for each m_UploadedImage in m_ExistingImage.get(v_ImageUploadFieldName) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my reviews/opinions: Phoca Download Good compatibility and actively developed. Unfortunately hacked on more...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
I've made a function that does this. How? Not sure how else to do this but I simply wrote a function in Zoho Creator for each instance that I knew a HTML entity would be submitted. So it doesn't decode every HTML in existence, only the ones I know will...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *