Assuming each is required, the following 212 results were found.
-
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 = r_Row.Event_Type; v_EventStart =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// // 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 through active users if(r_User.get("status") == "active") { v_Email =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there are zeros... But I'm keen on avoiding using loops where possible so we don't breach a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
need the profile) r_UserDetails = zoho.crm.getRecordById("users",v_UserID); if(!isnull(r_UserDetails.get("users"))) { for each r_User in r_UserDetails.get("users") { if(!isnull(r_User.get("profile"))) { v_UserProfile = r_User.get("profile").get("name");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
l_Attachments = zoho.crm.getRelatedRecords("Attachments","Contacts",v_CrmContactID,1,200,m_SortCriteria); for each r_Attachment in l_Attachments { if(r_Attachment.get("id") != null) { v_AttachmentEndpoint = "https://www.zohoapis.com/crm/v2/Contacts/" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
want to research this often so here's the quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list variable: l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// // initialize my list to populate l_CheckDates = List(); // // loop through generated list and add dates for each index v_Index in l_GeneratedList { if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
type :GET connection:"zinventory" ]; m_Accounts = Map(); if(!isnull(r_ChartOfAccounts.get("chartofaccounts"))) { for each r_Account in r_ChartOfAccounts.get("chartofaccounts") { m_Accounts.put(r_Account.get("account_name"),r_Account.get("account_id"));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
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(); m_InvoiceLineItem.put("item_id",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
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; c_Customer =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
p_TicketID + "/attachments" type :GET connection:"zdesk" ]; l_AttachmentDetails = ifnull(r_Attachments.get("data"),{}); for each r_Attachment in l_AttachmentDetails { m_Attachment = r_Attachment.toMap(); v_Endpoint = m_Attachment.get("href") + "?orgId="...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
{ l_ZB_ContactPersons = r_ZohoBooks_CustomerDetails.get("contact").get("contact_persons"); for each m_ZB_Person in l_ZB_ContactPersons { if(!m_ZB_Person.get("email").isBlank() && l_ZB_InvoiceRecipients.isEmpty()) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
in ZohoCreator l_CsvLines = List(); l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name; for each c_Product in l_ApplicableProducts { l_CsvRow = List(); l_CsvRow.add(c_Product.Photo);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
other apps may create similar webhooks so you need to make sure the script below is looking for your custom webhook for each m_ThisWebhook in r_ShopifyWebhooks.get("webhooks") { if(m_ThisWebhook.get("id") != null) { // // my app is the only one using...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
reminding staff to convert the lead. // l_RelatedTasks = zoho.crm.getRelatedRecords("Tasks", "Contacts", p_ContactID); for each m_RelatedTask in l_RelatedTasks { if(!isNull(m_RelatedTask.get("Subject"))) { if(m_RelatedTask.get("Subject")=="Follow Up Non...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
parameters:m_Params connection:"my_projects_connection" ]; l_PastEvents = ifnull(r_PastEvents.get("events"),List()); for each m_PastEvent in l_PastEvents { // // convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM......
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
in deluge that takes a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
if(r_SearchResults.get("code") == 0) { l_SearchResults = r_SearchResults.get("estimates"); for each m_Estimate in l_SearchResults { if(m_Estimate.get("estimate_number").equalsIgnoreCase(v_QuoteRef)) { if(m_Estimate.get("customer_id") == v_CustomerID) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
r_Events = invokeurl [ url :v_Endpoint_Events type :GET headers:m_Header ]; for each m_Event in r_Events { if(m_Event.get("id") != null) {... do stuff } } Source(s): Zoho Deluge: Difference between isBlank(), isNull() and isEmpty() functions
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *