Assuming isnull is required, the following 79 results were found.
-
v_OldKey = v_OldInvoiceItemID + "|" + v_OldInvoiceLineItemQuantity + "|" + v_OldInvoiceItemRate; if(!isnull(m_NewLineItems.get(v_OldKey))) { m_LineItem.put("salesorder_item_id",m_NewLineItems.get(v_OldKey)); } l_UpdateLineItems.add(m_LineItem); } // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
records (and approved) and determine if it clashes with the requested dates: for each r_TimeOff in l_AllTimeOffs { if(!isnull(r_TimeOff.get("Employee_ID"))) { v_ThisStatus = r_TimeOff.get("ApprovalStatus"); v_ThisFrom = r_TimeOff.get("From").toDate();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
// 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 be sorted alphabetically in reverse...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// // transform variables for main record v_QuoteName = ifnull(r_QuoteDetails.get("Name"),"Test Quote"); if(!isNull(r_QuoteDetails.get("Contact_Name"))) { r_ContactDetails = zoho.crm.getRecordById("Contacts",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); // // check if owner and get matching salesperson ID if(!isnull(r_SoDetails.get("Owner"))) { v_OwnerID = r_SoDetails.get("Owner").get("id"); v_Filter = "crm_reference_id=" + v_OwnerID;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
// output response info r_CreateSO; // read response if(!isnull(r_CreateSO.get("salesorder"))) { v_SalesOrderID = r_CreateSO.get("salesorder").get("salesorder_id"); // v_AddressIndex = 0; m_ShippingAddress = Map(); // set field api names that we will...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
r_GetFullRecord = zoho.creator.getRecordById(v_AppOwner,v_AppName,v_ReportName,v_CreatorQuoteID,"joels_creator"); if(!isnull(r_GetFullRecord.get("data"))) { r_CreatorRecord = r_GetFullRecord.get("data"); v_CreatorPhotoUrl =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_OrgAccountRecord = 123456789012345678; // // 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")...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
each r_Result in l_SearchResults { // check that there is an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // stop looping if less than 200...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
uploading a file to the newly added row in that subform (on user input). This sets the document name for display later: if(!isnull(row.Document_File)) { v_FileDetected = row.Document_File; if(v_FileDetected.contains("_")) { v_SubstringStart =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url = "https://zohoapis.com/crm/v2/settings/inventory_templates/" + v_TemplateID +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
+ v_BooksOrgID type :GET connection:"zinventory" ]; m_Accounts = Map(); if(!isnull(r_ChartOfAccounts.get("chartofaccounts"))) { for each r_Account in r_ChartOfAccounts.get("chartofaccounts") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
// // resolve connection details if(!isNull(r_ShopifyConnection.get("data"))) { m_Data = r_ShopifyConnection.get("data"); v_ShopifyID = ifnull(m_Data.get("Shop_ID"),""); v_APIVersion = ifnull(m_Data.get("API_Version"),""); v_AccessToken =...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
= 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 Converted Lead") { m_Delete = map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
between your Zoho People and Zoho Analytics instances failed. The last synchronization data we have is as follows: "; if(!isNull(m_DataSourceInfo.get("datasourceName"))) { for each v_DataSourceKey in m_DataSourceInfo.keys() { v_Message = v_Message + " "...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?) if(!isNull(m_PastEvent.get("scheduled_on"))) { if(m_PastEvent.get("scheduled_on").contains(" ")) { l_ThisDateTimeEventParts =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
for each m_Result in l_MatchedProducts { // ensure we are looping through results and not a search error if(!isNull(m_Result.get("id"))) { v_CountTotal = v_CountTotal + 1; // // keep the first one in results if(v_KeepID == 0) { v_KeepID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
value doesn't exceed the column size p.SetValue(Row, ValueToConvert, null); } } catch (Exception e) { // Only handle ColumnIsNull and NullReference Exceptions if (e.GetBaseException() is Microsoft.SqlServer.Dts.Pipeline.ColumnIsNullException ||...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *