Search - Joel Lipman .Com

1. Zoho Books: System Values Maps: / Zoho /; What? A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then ...; Created on 07 November 2023
2. 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
3. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; What? A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are ...; Created on 10 September 2021
4. Zoho Creator: Assign an integration field value with an integration value: / Zoho /; What? This is a quick article to help anyone encountering this gotcha: I have an integration field, if someone changes it, I want to save the value to the record immediately. Why? If you try to ...; Created on 27 July 2021
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. Zoho CRM: Make Upload File Field Mandatory: / Zoho /; ... and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My file upload field is called "Order Confirmation". v_OrderType = ZDK.Page.getField('Order_Type').getValue(); if ...; Created on 18 December 2024
17. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... if there is reason to update it then let's update CRM API v7 style if(l_NewLineItems.size() > 0) { // // build request to send to CRM v7 // m_RecordData should have value from last iteration m_UpdateQuote.put("Subject",m_RecordData.get("Subject")); m_UpdateQuote.put("Quoted_Items",l_NewLineItems); l_RecordsToSend ...; Created on 18 December 2024
18. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... ensuring you change the link's p_Intent value to Decline: // should be something like &p_Intent=Decline&p_QuoteRef=%EstimateNumber%&p_CxID=%CustomerID% When the end customer clicks on either ...; Created on 04 November 2024
19. Zoho Creator: Input Color Picker: / Zoho /; ... users to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click ...; Created on 14 October 2024
20. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024