Assuming loop is required, the following 86 results were found.
-
// // I can see 2 api names for lookups // userlookup221_2 // Requires_Approval_Users My full snippet of code // // loop through users to find the approver for each m_User in l_Users { if(m_User.get("Job_Title").equalsIgnoreCase("CFO")) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? You might already be familiar with some of the trigger options below but one that worked...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200, "Year_Month:equals:2021-06") { v_ThisEventTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
l_BooksShippingAddress = {"address","street2","city","state","zip","country"}; // loop through the CRM Sales Order address fields and build map of address to Books for each v_AddressPart in l_CrmShippingAddress {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
c_Wednesday = Collection(); c_Thursday = Collection(); c_Friday = Collection(); c_Saturday = Collection(); // // loop through Monday subform for each r_Row in input.Mondays { if(r_Row.In_Effect) { // get Monday entries/rows v_EventType =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
{ // // parse events out of the webhook (a list) l_Events = m_Body.get("events").toJSONList(); // // loop through the events for each r_Event in l_Events { if(!isnull(r_Event.get("eventCategory"))) { // // event type will be UPDATE and eventCategory...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonOrders = List(); // // loop through orders in response v_OrderNodePart = "Order"; v_OrderNodeName = v_OrderNodePart + "Array"; x_OrderNode =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the number of days ago (list of dates to check) l_GeneratedList = leftpad(" ",v_DaysAgo).replaceAll(" ",",").toList(); // // loop through for each index v_Index in l_GeneratedList { // output to developer for debug purposes v_Date =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // now lets loop through a dynamic page list for each v_Page in l_Pages { // // specify which page m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
whether to update or create. - Check if Shipment already exists on system to determine whether to update or create. - Loop through eBay payments to record all the different payments received. Date Modified: 2023-03-14 (Joel Lipman) - Resolved fix of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
label because -3 often displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in l_SalesOrderLineItems { m_InvoiceLineItem = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible image URL to/from ZohoWriter. Loop through active users in ZohoCRM. Merge the HTML email signature with the fields evaluated. Function: fn_Workdrive_HostImage I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
.then(function(response) { // store the search results into an array var recordArr = response.data; // quick loop to find the preferred name for(var index in recordArr){ v_GreetingName = recordArr[index].Nick_Name; break; } // if not blank then let's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; if(r_ShopifyWebhooks.get("webhooks") != null) { // // loop through to see if our custom notifications exist // note that installing other apps may create similar webhooks so you need to make...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
record. // // initialize m_Blank = Map(); // // evaluate v_BooksOrgID = organization.get("organization_id"); // // loop through line items for each m_LineItem in salesorder.get("line_items") { r_BooksItem = zoho.inventory.getRecordsByID("items",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
*/ // v_CountUnique = 0; v_CountTotal = 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
items from the quote / if deposit, then don't include the original line items if (v_InvoiceType == "Final Balance") { // now loop through the quoted items / line items for (i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
3.X a.name AS 'display_name' FROM my_joomla_db.jos_users a ORDER BY a.id; A bit more to do: PHP file So I needed to do a loop and rather than complicate things with stored procedures and cursors, it's likely if you're using either Joomla or Wordpress...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
For one thing, the accidental search for "Jane" and pressing the Enter key, no longer goes off into the interminable loop that is "loading".
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB