Assuming ifnull is required, the following 68 results were found.
-
the images associated in the subform: void Standalone.fn_DownloadAndCacheAttachments(string p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,""); c_TicketRecords = QC_Report_Table[Ticket_Number == v_TicketRef]; for each c_TicketRecord in c_TicketRecords...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
]; //info r_Analytics; // // parse response if(r_Analytics.get("status") == "success") { m_ResponseData = ifnull(r_Analytics.get("data"),Map()); l_DataSources = ifnull(m_ResponseData.get("dataSources"),List()); for each m_DataSource in l_DataSources {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
= invokeurl [ url :v_EndpointEvents type :GET 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
= false; v_EstimateID = "-"; v_OrgId = "123456789"; v_Output = "Unable to process request"; // // evaluate v_Intent = ifnull(input.p_Intent,"-"); v_QuoteRef = ifnull(input.p_QuoteRef,"-"); v_CustomerID = ifnull(input.p_CxID,"-"); // // Search ZohoBooks...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
+ p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :GET connection:"zcrm" ]; l_RecordData = ifnull(r_QuoteDetails.get("data"),List()); for each m_RecordData in l_RecordData { // // apply changes to any of the line items l_NewLineItems =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
connection:"crm_api_v2" ]; // // retrieve results if(!isNull(r_Coql.get("info"))) { v_MatchedCount = ifnull(r_Coql.get("info").get("count"),0); } if(!isNull(r_Coql.get("data"))) { v_MatchedAccountID = ifnull(r_Coql.get("data").get(0).get("id"),0); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
*/ // // declare v_TotalClashes = 0; v_TotalDeptEmployees = 0; v_OutputMessage = ""; // // get record details v_RequestId = ifnull(p_RequestID,0).toLong(); v_DeptName = ifnull(p_Dept,""); v_GivenDateFrom = p_LeaveFrom; v_GivenDateTill = p_LeaveTill;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html */ v_Page = ifnull(p_Page,1); v_PerPage = ifnull(p_PerPage,200); m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"];...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
{ for each r_User in r_Users.get("users") { // loop through active users if(r_User.get("status") == "active") { v_Email = ifnull(r_User.get("email"),""); v_LastName = ifnull(r_User.get("last_name"),""); // // single out this person (can be removed after...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_Header.put("X-Shopify-Access-Token", v_AccessToken); // // graphql v_SearchSKU = ifnull(p_SKU,""); v_GraphQl = "{ productVariants(first: 1, query: \"sku:'"+v_SearchSKU+"'\") { edges { node { id price sku title barcode inventoryItem { id } product { id...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
(??? - ???) - ******************************************************************************* */ v_CandidateZohoID = ifnull(p_CandidateID,0); r_Associated = invokeurl [ url :"https://recruit.zoho.com/recruit/v2/Candidates/" + v_CandidateZohoID +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
ChatGPT to build on: // // initialize m_Response = Map(); v_Message = message.trim(); l_Messages = List(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last 10 minutes v_MinutesAgo = 10; v_FromTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
r_ContactDetails = zoho.crm.getRecordById("Contacts",v_ContactID); v_ContactNumber = ifnull(r_ContactDetails.get("Mobile"),r_ContactDetails.get("Phone")); } // // ---------------------- QUOTE DATES ----------------------...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
For: Quote Date: Quote By: Item Description Quantity Unit Price Unit Discount 0) { v_LineItemTotal = 0.00; v_ThisQuantity = ifnull(c_Quote.Quantity,1).toLong(); v_TotalQuantity = v_TotalQuantity + v_ThisQuantity; // v_PriceDisplay =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
type :GET parameters:m_Config headers:m_Header connection:"my_analytics_connection" ]; // // parse response l_DataRows = ifnull(r_PurchaseOrders.get("data"),List()); // // build up related list header row l_HeaderColumns = List();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
:"https://www.zohoapis.eu/crm/v7/coql" type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_UniqueProducts = ifnull(r_CoqlUniqueProducts.get("data"),List()); for each m_Product in l_UniqueProducts { l_DebugNotes = List(); v_CountUnique =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
so if we went with the Regex to truncate, we would need to get rid of the excess escaping backslashes: v_ListPrice = ifnull(m_ZCrm_LineItem.get("List_Price"),0); m_ZBooks_LineItem.put("rate",v_ListPrice.toString().replaceAll("^(\d+\.\d{2})\d*$", "$1",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
type :GET connection:"j_crm" ]; // // should only be 1 record but respecting JSON data structure and parse l_Datas = ifnull(r_QuoteDetails.get("data"),Map()); for each m_Data in l_Datas { l_QuotedItems = ifnull(m_Data.get("Quoted_Items"),List()); break;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// get current user id m_UserTypes = Map(); r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserTypes); l_Users = ifnull(r_Response.get("response").get("users"), {}); v_CurrentUserID=0; for each r_User in l_Users {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
going to query a message to the ChatGPT bot: // // initialize m_Response = Map(); v_Message = message.trim(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last 10 minutes v_MinutesAgo = 10; v_FromTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *