Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow unity press board wreck shake decay Sheet2 contains the following:: A ---------------...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will work, but...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Horizon Lake Lawn London Mountains New York Paris Piscine (Swimming Pool) Rooftop Snow Theatre Tokyo Warehouse More Art Terms These are ones mentioned by YouTubers that had an effect on the output (ones I didn't make an image of didn't work for me but I...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 " + v_Icon_TwitterHTML + " " + v_Icon_LinkedInHTML + " " + v_Icon_PinterestHTML + " " + v_Logos_PartnersHTML + " Important Terms & Conditions: By choosing to purchase or hire... "; // // get all active users in CRM m_UserMapping = Map(); v_Endpoint =...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 the following: I've put some really small print here just so that you don't really read this and appreciate that we have terms and conditions like every other business. Page of Copyright © My Company Ltd. All Rights Reserved. Additional Notes to...

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

SQL: Use CASE for Relevance columnhttps://www.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET...

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

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 line items table would display on the first page, the product line items would then print on the second page, with the terms and conditions or small print notes on a third page. How? Printing to PDF or saving as a PDF lets me preview the page breaks...

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