Assuming loop is required, the following 86 results were found.
-
This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which have workflows triggered from many deltas/changes. Why? Some...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Shopify. Why? The use-case was that I wanted to search Shopify using a Product SKU. Community forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
below). // ****************** CODE USING SEARCHRECORDS **************** // // init v_RecordID = 1234567890123456789; // // loop through 5 pages of 200 records = 1000 records l_Pages = [1,2,3,4,5]; // // set search criteria v_SearchCriteria =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the displayed rows (not been deleted) var l_existingSubformRows = ZDK.Page.getField('Deployment_Rate_Log').getValue(); // loop through to exclude any rows we don't want based on criteria l_NewSubformRows = new Array(); for (i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
void fn_AB_GenerateVacanciesCandidatesAssociations() Workflow: - Trigger: Standalone function triggered on execute Purpose: Loops through all candidates and creates records referring to the Candidate Ref and Job Opening Date Created: 2023-02-02...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
using System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through properties using System.Threading; // for threading [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute] public class...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Method 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
ReturnedHTMLTableRows=%ReturnedHTMLTableRows% StringSplit,ReturnedHTMLTableRows,ReturnedHTMLTableRows,| RowIndex:=0 Loop, %ReturnedHTMLTableRows0% { RowIndex++ ReturnedHTMLTableColString:=ReturnedHTMLTableRows%RowIndex% ; split the row into columns...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
with a ListView with rows that can be double-clicked to open the profile. As an overview: Setup a standard AutoHotkey GUI Loop through Google Chrome Profile folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
folder to keep in Green and the one to delete in Red. - Lists failed deletions if there are any. - Changed browsing code to loop through folder of files to REMOVE. - Changed code to loop through an array of files rather than the directory. - Added...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
v_UidStr.substring(6,8) ); l_Parts.add( v_UidStr.substring(8,10) ); l_Parts.add( v_UidStr.substring(10,12) ); // loop through parts for each v_Element in l_Parts { v_Remainder = v_Element.toLong() % 26; l_Output.add( l_Alphabet.get( v_Remainder ) ); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
0006 Test Product 1 TEST001 test2@joellipman.com 0007 Test Product 1 TEST001 test2@joellipman.com The code is a for loop which iterates through each row, assigning an entry for a new product or account, and specifying the quantity for each. How? So...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
v_FileInternalName = row.Upload_File; // looping through rows here but it wants the internal name here eg. "1234567890123_temp.pdf" // // build the URL l_BuildUrl = List:String(); l_BuildUrl.add(v_CreatorDownloadBase); l_BuildUrl.add(v_AppOwnerName);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
a list to hold the keys which we will use to sort in ascending/descending order and a map created to hold all the records. Loop through the sample map to create the new map we can sort as well as to add keys to the list declared previously. Sort the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
a text editor, then escape the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop through removing HTML tags and while we're at it, storing it in a list for Zoho Deluge: First of all, here's the HTML SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= 32; // // set to the Account record of our organization v_OrgAccountRecord = 123456789012345678; // // loop through all users r_Users = zoho.crm.getRecords("users"); if(!isnull(r_Users.get("users"))) { for each r_User in r_Users.get("users") { // loop...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// // map string replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" "," "); // // loop through each of the above replacing where found for each v_HtmlKey in m_HtmlEntity.keys() { v_StringToDecode =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
How? To resolve this, I'm building on top of my initial GraphQL query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *