Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the responses returned as successful, but the target fields did not...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 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 CRM but I want to transform/translate one of the column values into the target How? So this...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 fields were mapped. Amazing but not as useful as it is interesting: Then you're into the penultimate step of the migration where you watch another but different progress animation which is possibly all your data being mapped, associated, and imported......

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 the color code nor ID were necessary in the end, I can use shortcode for getting the tag. Note that on a fresh CRM instance where no tags have been used previously, I would use the code above to maintain tag colors. Here's the shortened version where...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 DATEPART(dayofyear, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM TableName WHERE ItemDate BETWEEN '01/01/2010' AND '08/01/2011' GROUP BY DATEPART(dayofyear, ItemDate), DATEPART(year, ItemYear), ItemName //...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Teams t ON t.TeamID=s.TeamID GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 rows get re-adjusted to fit the data and lose that consistency. A Workaround: New line inserted before and after So this is where I am at the moment without VBCode and other suggestions. Instead I add a newline in front of and after the smallest data...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

MySQL last year week month day trend periodshttps://www.joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(NOW()); -- BEFORE: count yesterdays total SELECT COUNT(id) FROM Table1 WHERE...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ' ' ) ) )) AS NotAlphaNumeric FROM YourDataSetTable WHERE ThisRecord = :UserSpecifiedID -- where :UserSpecifiedID is one of the report parameters (Oracle local variable) -- where...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 + ' ' + DATA_TYPE + '(' + CAST(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(10)) + ')' END FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName ORDER BY ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ';'; EXEC(@TableDeclaration); -- Get First Column...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 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 "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load). How? The...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 @stringtoFind, @stringtoReplaceWith) AS newText, `content_column` as oldText FROM `MYTABLE_content` WHERE `content_column` LIKE CONCAT('%',@stringtoFind,'%') -- yields id title OldFoundInOld NewFoundInOld OldFoundInNew newText oldText 1 Article 1 yes no...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love Advanced Web Statistics (awstats) but this was so that you could have your...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table:...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 of the Operating Systems in implementing multiple desktops. So if you have a Mac or Linux system, you will know of a feature where you can have another virtual desktop on your device. For those that don't know it, the feature is similar to mobile phones...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 into a CRM Mail Merge template and send it off for signing, then return the Signed document attached to the initial record (where the button was). Why? If anyone has the envious task of sending a document out for signing by a customer, you will know...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article'...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB