Assuming through is required, the following 143 results were found.
-
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: *
-
the webhook, scroll to the end of that row listing your webhook and click on the button Send test notification. It will go through your CRM which will in turn forward the JSON payload to your Zoho Creator record: I'll leave it up to you to parse that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
as to display empty custom related lists. Why? Because I keep forgetting how to do this and it takes about an hour to go through the documentation and get a working solution. How? So the article below shows how to do this Zoho CRM and how to do it in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
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 Books, and retrieving the salesperson_id. Also I have a connector to ZohoBooks called "joel_books"....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
and vice-versa. This can get more complex when there are a lot of fields in the mix. How? I'm using this article to go through various methods I tried to prevent this from happening: First - Off: The one workflow to rule them all In the first instance,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
in via your email (now comment this out in your CRM before it drives you insane) but also, and if setup correctly, sent through to your Creator app, all without having to speak to someone from eBay. Done! Error(s) Encountered 22112 - Missing property...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- 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: *
-
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: *
-
{ // // 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: *
-
referring to 2 status fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first time I'm using it so I'm documenting it....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_ShopifyAPI.Shop_ID; v_ShopifyApiVersion = r_ShopifyAPI.API_Version; v_AccessToken = r_ShopifyAPI.Access_Token; // // send through m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token", v_AccessToken);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
that took into account "Delivery" as a separate line item on the purchase order. I'm writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
v_CsvLine := StrReplace(v_ListViewHeaders,"|", ",") ",Process`r`n" FileAppend, %v_CsvLine%, %v_RunFolder%\Log.csv ; Loop through directory of files Loop, Files, %v_FolderToSearch%\*.* , R { ; init v_OriginalFile := A_LoopFileName v_OriginalFileFull :=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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: *
-
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 CRM
- Language: *
-
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: *
-
Who uses ZohoInventory for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory enabled. But to flesh that out a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
+ " record" + v_Grammar + " are duplicates!"; // // return a distinct list l_Customers2.removeAll(l_Customers1); // // loop through and output to user for each v_DistinctCustomer in l_Customers2 { v_CountDiscrepancies = v_CountDiscrepancies + 1;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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 add...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *