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. Warning: Save failed. Another menu item has the same alias: / Joomla /; What? A quick article for Joomla CMS version 3.x on resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is ...; Created on 13 March 2015
3. MySQL Updating a database table from another table: / MySQL /; What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...; Created on 22 October 2014
4. 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
5. Link to a Joomla article from within another article: / Joomla /; What? Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article ...; Created on 04 December 2012
6. MySQL: Find records in one table that are not in another.: / MySQL /; ... like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers ...; Created on 25 February 2011
7. Another ASCII Extended Character Set for PC: / Windows OS /; Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold ...; Created on 14 April 2010
8. Migrate MediaWiki to another server: / MediaWiki /; Old Server mysqldump -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that ...; Created on 23 September 2009
9. Zoho Creator: Input Color Picker: / Zoho /; ... Add a radio field type, I've called it "Color Picker" Add a single line text field, I'm calling it "Hexadecimal" Add another single line field, I'm calling it "RGB Value" Step 1: Code to complete ...; Created on 14 October 2024
10. ZohoCRM: Make either Mobile or Email mandatory: / Zoho /; ... Repeat these steps to add another rule: Call it "If Mobile Blank then Email Required" Select the Mobile/Phone field as the primary field to control this rule Set the condition that the ...; Created on 03 October 2024
11. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... the document. I know this exists in ZohoSign already but we don't expect staff to go to another app to check on this and would rather see it directly in ZohoCRM on the relevant record. So the more ...; Created on 06 August 2024
12. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... Pre-amble Have all the images you want to use ready for uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section ...; Created on 25 July 2024
13. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. ...; Created on 09 July 2024
14. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... but according to documentation (to be taken with a grain of salt), the scope should be ZohoInventory.settings.READ. I have another connection called "zinventory" which is used here to retrieve the item/product ...; Created on 23 May 2024
15. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... = User Acceptance Testing) to ensure this behaves as expected. So I found another function was being run when a contact record is created and I appended this snippet of code to the end of it. Note tha ...; Created on 14 May 2024
16. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... for a customer who simply wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table ...; Created on 07 May 2024
17. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... API to detect what webhooks exist, it can only detect what webhooks it initialized. If you added webhooks via another app or via the Shopify Admin interface, then the following code won't be able to check ...; Created on 22 April 2024
18. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... another key) Zoho Deluge Here's the code to retrieve all the product categories. We need this to get the count of all products (if there's another way, I'd love to hear it). We don't have more than ...; Created on 15 April 2024
19. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a ...; Created on 25 March 2024
20. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... for more information. If your widget sits on an external server, it won't connect. I have tried publishing the Creator Widget page (doesn't work); then I have tried embedding the Widget page into another ...; Created on 14 March 2024