Assuming ifnull is required, the following 68 results were found.
-
the following: v_GivenDate = '2021-09-21'; m_Ordinals = {1:"st",21:"st",31:"st",2:"nd",22:"nd",3:"rd",23:"rd"}; v_Ordinal = ifnull(m_Ordinals.get(v_GivenDate.toString("d").toLong()),"th"); info v_Ordinal; // yields st
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
a specific user: r_ZohoResponse = zoho.crm.getRecordById("users",r_DealDetails.get("Owner").get("id")); l_MatchingUsers = ifnull(r_ZohoResponse.get("users"),{}); for each r_UserDetails in l_MatchingUsers { info r_UserDetails.get("id"); } List CRM Users...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the Creator page, retrieve the title and content of the modal dialog from the record by using the following: v_NotifyID = ifnull(input.p_NotifyID,0).toLong(); r_NotifyDetails = Notifications[ID == v_NotifyID]; v_Text = r_NotifyDetails.Title; v_Content =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= List(); m_UnsortedRecords = Map(); // for each r_Record in l_MyListUnsorted { // field we want to sort by v_SortingKey = ifnull(r_Record.get("date"),""); if(!isNull(v_SortingKey)) { // as this is a date from CRM (atomic date format), arrange so it can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= zoho.crm.createRecord("Tests_X_Contacts", m_Link); } Code to Add a value to a multi-lookup (on Update Record): v_DealID = ifnull(input.p_DealID,0); if(v_DealID != 0) { m_Link = Map(); m_Link.put("Deal", v_DealID); m_Link.put("Product",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= zoho.crm.getRecordById("Quotes", 123456789012345678); // // transform variables for main record v_QuoteName = ifnull(r_QuoteDetails.get("Name"),"Test Quote"); if(!isNull(r_QuoteDetails.get("Contact_Name"))) { r_ContactDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the Opportunity/Deal/Potential record. In this example, the custom field is called "Division": // // init v_DealID = ifnull(p_DealID,0); r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID); // // Map users/owners division to this deal...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"https://www.zohoapis.com/crm/v6/org/taxes" type: GET connection: "zcrm" ]; info r_TaxRates; // list tax rates l_Taxes = ifnull(r_TaxRates.get("org_taxes").get("taxes"),List()); Source(s): Zoho CRM: Modifying Special Fields: Customize Tax Rates
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
if(!isnull(r_GetFullRecord.get("data"))) { r_CreatorRecord = r_GetFullRecord.get("data"); v_CreatorPhotoUrl = ifnull(r_CreatorRecord.get("Display_Photo"),""); if(v_CreatorPhotoUrl!="") { // // download photo from your Creator (change connection and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ // // an error-prone one-liner so that we don't hit an execution statement limit v_ProductSKU = ifnull(r_ShopifyProduct.get("variants").get(0).get("sku"), "UNKNOWN"); m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id")); // // getting the last ID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
m_NewLineItem.put("Quoted_Items.Description", r_LineItem.get("Description")); v_Quantity = (ifnull(r_LineItem.get("Quantity"),1).toDecimal().round(2)).toString().replaceAll(("(?
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the English ordinal bit I used: m_Ordinals = {1:"st",21:"st",31:"st",2:"nd",22:"nd",3:"rd",23:"rd"}; v_Day3_Ordinal = ifnull(m_Ordinals.get(v_NextDay.toString("d").toLong()),"th"); Then in my HTML table, I can use the headers: v_Day1_Header = " Today "...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// Parse body of Xero webhook and update respective CRM record // m_Body = ifnull(m_Payload.get("body"),m_Blank); // // check if events was in the payload if(!isnull(m_Body.get("events"))) { // // parse events out of the webhook (a list) l_Events =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
you like): string DataCleansing.fn_DecodeHtmlEntities( string p_StringToDecode ) { // initialize v_StringToDecode = ifnull(p_StringToDecode,""); // // map string replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" ","...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
:"https://www.zohoapis.eu/crm/v7/coql" type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_SortedProducts = ifnull(r_CoqlSortedProducts.get("data"), List()); Source(s): Joel Lipman - ZohoCRM: Process all records of a module Zoho Deluge -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
we want to check for v_LeadStatus = ""; if(!isnull(m_Webhook.get("record"))) { // // extract lead status v_LeadStatus = ifnull(m_Webhook.get("record").get("Lead_Status"),""); } // // if user profile is not allowed to make this change...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// ************************************************** CREATOR ************************************************** v_ItemId = ifnull(p_InventoryItemID,0); v_PublicUrl = ""; // // send Zoho Creator the inventory ID v_AppOwner = "JoelGoHappy"; v_AppName =...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
+ l_Params.toString("&"); r_AccessToken = invokeUrl [ url: v_Url type: POST ]; // // output v_AccessToken = ifnull(r_AccessToken.get("access_token"), ""); // // use the access token to query requests m_Header = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
*/ // // initialize v_ShipmentStatus = "error"; v_TrackingNumber = ifnull(p_TrackingNumber,0); // // specify your DHL API Key (no need for the secret or base64 encoding) v_DHL_API_Key = "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"; // // build up header...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
[ url: "https://www.zohoapis.com/crm/v3/settings/business_hours" type: GET connection: "mycrmconnection" ]; m_OrgDetails = ifnull(r_OrgDetails.get("business_hours"),{}); if(m_OrgDetails.get("business_days") != null) { // // let's format a little as the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *