Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. T-SQL: Parse an XML value: / Transact-SQL /; What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...; Created on 27 March 2014
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. Split a row into multiple rows based on a column value: / Transact-SQL /; Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that ...; Created on 23 August 2013
7. Search a database for a value and count matching rows: / Databases /; What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...; Created on 05 November 2012
8. 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
9. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again ...; Created on 01 August 2012
10. 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
11. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources ...; Created on 02 December 2011
12. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... = zoho.bookings.getWorkspaces("joels_connector"); l_Workspaces = r_WorkspaceResults.get("response").get("returnvalue").get("data"); for each r_Workspace in l_Workspaces { if(!isnull(r_Workspace.get("id"))) { v_WorkspaceName ...; Created on 23 June 2021
13. 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
14. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... can be workflow, approval, or blueprint. If trigger is not mentioned, the workflows, approvals, and blueprints related to the API will get executed. Enter the trigger value as [] to not execute the workflows. ...; Created on 16 June 2021
15. 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
16. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... = "(field0:equals:" + v_UserID + ")"; l_SearchResults = zoho.crm.searchRecords("Vendors_X_Users",v_SearchCriteria); Code to Add a value to a multi-lookup (on Create Record): // sample code when ...; Created on 28 April 2021
17. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... "link_Docs": 0 } ], The most logical thinkers would say that you simply need the download_Url value and prepend the CRM base URL such as https://crm.zoho.com + v_download_Url... But that ...; Created on 02 February 2021
18. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... ... this is the ID of the Leave form record. p_Dept as the name of the "Department" ... this is found on the Employee form not the leave form. p_LeaveFrom this is the value of "From" on the "Leave" form ...; Created on 10 December 2020
19. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... am sending as parameters (in this case "Quotes"). As the actual parameter value, select the form which is the singular of the records that you are sending (in my example here I have a form called "Partners ...; Created on 06 December 2020
20. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... or "DNS Zone Editor": If the subdomain has a CNAME record, modify it as per the below (not the "Name" just the "CNAME" value) Name will be something like .mydomain.com. and www..mydomain.com. TTL = 300 ...; Created on 17 November 2020