Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 a function with a string parameter called "crmAPIRequest". It has to have this name. It is a reserved variable and will contain all the webhook payload data. When a webhook is pointed at it, the crmAPIRequest variable will hold the payload. Same with...

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

Select unique values in Microsoft Excel columnhttps://joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1)) /* Count the number of unique text and number values in cells B2:B10 (which must not contain blank cells) (7) */ =SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1)) /* Count the number of unique...

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

MySQL: Find all non-alphanumeric rowshttps://joellipman.com/articles/database/mysql/mysql-find-all-non-alphanumeric-rows.html

09 September 2013 all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that...

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

Joomla Development: Possible XML Filtershttps://joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 HTML Allows basic HTML ARRAY Forces value to be an array PATH Forces value to be a file path USERNAME Forces value to only contain characters allowed in the selection of a Joomla username UNSET Completely remove any input RAW Allow any content URL...

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