Search - Joel Lipman .Com

1. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; What? This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in ...; Created on 08 October 2021
2. Excel - Check a column for values found in another column: / Excel /; What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration ...; Created on 14 February 2019
3. Trim values along with the tab: / MySQL /; What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. ...; Created on 13 June 2016
4. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
5. Excel: Find values in one column that are not in another: / Excel /; What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...; Created on 06 March 2014
6. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( ...; Created on 26 October 2012
7. Select unique values in Microsoft Excel column: / Excel /; ... This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the ...; Created on 03 July 2012
8. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... on the left grey margin of this and select "Insert Row" then "Below". Repeat with all values you want to compare. For each Data cell, Set the background fill expression as per the MDX expression ...; Created on 02 December 2011
9. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... = "div.zc-Calendar_Day_Select-group"; // // set initial hidden date field input.Selected_Date = zoho.currentdate; input.Starting_Date = zoho.currentdate; // // set the values for the calendar select ...; Created on 09 March 2022
10. Zoho CRM: searchRecords with sorted results: / Zoho /; ... Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: // ****************** CODE USING ...; Created on 10 February 2022
11. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... == "Customer_s_Timezone") { // loop through all the picklist values of this dropdown for each r_TimeZone in r_Field.get("pick_list_values") { if(r_TimeZone.get("display_value").containsIgnoreCase(v_TimeZone)) { v_CustomerTimeZon ...; Created on 15 December 2021
12. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel ...; Created on 07 December 2021
13. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... Source(s): Zoho Creator/Deluge: Insert rows in Subform Quick refresher: // declaring the row = .(); // assigning values for various subform fields in the row . = ; . = ; // declaring ...; Created on 17 November 2021
14. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
15. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... split values by commas l_FieldValues = r_Data.toList(","); if(l_FieldValues.size()>0) { m_Record.put("EmployeeID",l_FieldValues.get(0)); } if(l_FieldValues.size()>1) { m_Record.put("Name",l_FieldValues.get(1)); } if(l_FieldValues.size()>2) { m_Record.put("Address",l_FieldValues.get(2)); } if(l_FieldValues.size()>3) { m_Record.put("Territory",l_FieldValues.get(3)); } info ...; Created on 26 August 2021
16. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting ...; Created on 30 July 2021
17. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and ...; Created on 16 June 2021
18. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... init l_CrmLineItems = List(); // // some sample values v_CrmProductID = "123456789012345678"; // // build up product details JSON to send m_LineItemProduct = Map(); m_LineItemProduct.put("id",v_CrmProductID); m_LineItem ...; Created on 17 May 2021
19. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... The Code to read, parse, create a holding record and generate a link for the customer portal user to click on: // accessing zoho.eu (not zoho.com) so adapt the 2 values v_CreatorBaseUrl = "https://creator.zoho.eu"; v_ZohoApisDC ...; Created on 02 February 2021
20. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a form/report: Click on the plus icon to create a new form Select a blank form, ...; Created on 06 November 2020