Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard in Zoho Analytics as we can't control the out-of-the-box...

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

Calculating Percentagehttps://joellipman.com/articles/ecommerce/calculating-percentage.html

20 May 2010 won vs total: Total = Won + Lost + Other Percentage = Won / Total * 100 eg. 33.33% = 1 / (1 + 1 + 1) * 100 Markup Margin Percentage: ( Sell - Cost ) / Cost * 100 = Markup Percent eg. ( 75 - 50 ) / 50 * 100 = 50% Gross Margin Percentage: ( Sell - Cost )...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 using PHP. This is the CSS though: #container { position: relative; } #content { position: relative; top: 0; width: 900px; margin: 0 auto; min-height: 500px; /* to stop footer coming up on empty pages */ background-image:...

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

CSS Printing - Page Break Inside with Headers and Footershttps://joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 set the page CSS: This will allow 3cm from the top for a header and 2cm from the bottom for a footer. @page { size: A4; margin: 3cm 1cm 2cm 1cm; } @page :first { size: A4; margin: 0cm 0cm 0cm 0cm; } If this works for you then brilliant because it didn't...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 { display: block; overflow: hidden; cursor: pointer; border: 2px solid #ff7058; border-radius: 20px; width: 140px; margin: 10px; } .onoffswitch-inner { display: block; width: 200%; margin-left: -100%; transition: margin 0.3s ease-in 0s; }...

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

PHP - Remove newlines and spaces from StyleSheethttps://joellipman.com/articles/web-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

03 January 2020 to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want: #copyright a{margin:10px 0 0...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Performance Report - Background colors based on dataset valueshttps://joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 a "Matrix" into the body of your report. Drag "ReportName" into the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left parenthesis Click on the dropdown of...

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

Vertically align an asterisk on a linehttps://joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 ul.listafter{ list-style-type:none; width:130px; height:130px; background:none; } ul.listafter li{ width:59px; height:52px; margin:0; padding:0; color: #000; background-color:red; border:1px solid #000; cursor:pointer; float:left; vertical-align:bottom;...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

07 May 2024 data to stay aligned. Using only DIV layers can cause a few unexpected layouts in ZohoCreator. The Quick Answer: the page margins Tackling the page margin on render, I wrap the whole lot inside a DIV layer with the key attribute zcpage-spacing:.........

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

Zoho Creator: Input Color Pickerhttps://joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 v_CssStyle = ""; v_CssStyle = v_CssStyle + ".zc-Color_Picker .my-color-picker{width:17px;height:17px;border:0 !important;margin-right:1px;}"; v_CssStyle = v_CssStyle + ".zc-Color_Picker .choice-table-cell span{padding:0 !important;}"; // get rid of...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 = o_ThisLineItem.List_Price; o_NewLineItem.Manufacturer = o_ThisLineItem.Manufacturer; o_NewLineItem.Margin = o_ThisLineItem.Margin; o_NewLineItem.Net_Total = o_ThisLineItem.Net_Total; o_NewLineItem.Product_Name = o_ThisLineItem.Product_Name;...

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

Ordered List of over 1000 Itemshttps://joellipman.com/articles/web-development/css/ordered-list-of-over-1000-items.html

08 February 2013 So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Applying a button and centering it in the RocketTheme Affinity templatehttps://joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 classes. Specified float:none to get rid of float:left Specified width of readon-wrap1 to the width of the button Specified margin:0 auto to center readon-wrap1 Original Code: New Code:

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

Crystal Reports: Exporting to Excel omits column headershttps://joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 as their respective column heading. Remove any ruler gridlines that don't truly serve a process (even if they're just for margin purposes)

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 the name of the dataset. Bring up the tablix properties (or the textbox you want to hide) Select "Visibility" in the left margin Type the following expression (where "Equipment" is the name of the dataset) =IIF(Sum(Fields!Counter.Value, "Equipment")...

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

CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 background (content section) I used the following CSS: #contentbox { position: relative; top: 70px; width: 900px; margin: 0 auto; padding: 7px 30px 75px 30px; clear: both; z-index: 7; /* Fallback for web browsers that doesn't support RGBa */...

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

AutoHotkey: Check Windows Folder Sizeshttps://joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 Desc := "This program will display folders and their respective sizes." Width := 500 Height := 360 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border +ToolWindow -Resize -MaximizeBox -MinimizeBox +OwnDialogs" BaseDir :=...

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

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

10 July 2019 the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter; display: table; margin: 0; padding: 5px 0 5px 15px; } ol > li { counter-increment: myCounter; display: table-row; } ol > li:before { content:...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 all the Google Chrome profiles available from your login." Version := "1.0" Width := 400 Height := 800 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border +OwnDialogs" TempDir := "C:\Windows\Temp" ;...

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

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

22 October 2021 I'm doing this inline and via code, Zoho automatically removes these. So instead, I am going to use negative/positive margins to move the tabs group up/down along with the form wrapper (so all the form is below the tabs group) and then a negative margin...

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