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

14 October 2024 !important;}"; // get rid of circular inputs v_CssStyle = v_CssStyle + ".zc-Color_Picker .customRadio+label{display:none !important;}"; // float the radio options to the left to be horizontal rather than vertical v_CssStyle = v_CssStyle +...

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

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

22 October 2021 And I add the following to my deluge script, to remove the label "Tabs": v_Css = ""; v_Css = v_Css + ".zc-Tabs-label{display:none !important;}"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Yields Then aligning these radio options horizontally: v_Css =...

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

T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 : This function returns a table populated with a row for each string value in the space separated string ** Assumptions : None ** Inputs : @StringInput = the space separated string values ** Outputs : Single table ** Output Rows : One row per space...

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

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

22 October 2020 to preserve functionality: /* On Off Switch CSS */ .onoffswitch { position: relative; width: 100%; -webkit-user-select:none; -moz-user-select:none; -ms-user-select: none; } .onoffswitch-checkbox { display: none; } .onoffswitch-label { display: block;...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 which yields the following: Then I get rid of the label with the following CSS: label.zc-Calendar_Day_Select-label{display:none !important;} Then get rid of the round circles for radio inputs / and ensured the cursor remained as a hand to indicate...

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

Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 ""; // // this line hides the delete/cross icon next to each row v_CssNotes = v_CssNotes + ".subformRow .form-group{display:none;}"; // // this line hides the "add new row" from every subform. v_CssNotes = v_CssNotes + ".zc-subform-addnew a{display:none...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 TBIF_LPARAM = $00000010 Const TBIF_COMMAND = $00000020 Const TBIF_SIZE = $00000040 Const I_IMAGECALLBACK = -1 Const I_IMAGENONE = -2 ;#End Region ;#Region Toolbar button state Const TBSTATE_CHECKED = $01 Const TBSTATE_PRESSED = $02 Const TBSTATE_ENABLED...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Intro I know there are a lot of articles on the WWW detailing this process but none of them really worked for me. I recently changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 pictures Installed MS Internet Explorer (only uses libraries) Program Size: 1,190Kb (fits on a floppy disk) Setup/Install: None, it's portable (can run off USB or media) Program Name: WebsiteThumbnailer_v0_6.exe Prefix: JWT So I need a FREE program that...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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

02 September 2012 align to the bottom ( line-height: 10px; vertical-align: bottom;). Here's the whole code: 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;...

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

Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 How? You might already be familiar with some of the trigger options below but one that worked was initially guessed as "none" but then later found in the documentation could also be an empty list []. So there are a few trigger options but I'm listing...

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 following styling (this will depend on the theme you are using): .zc-Save_and_Close-group .decision-box-field label{ display:none !important; } .zc-Save_and_Close-group label{ cursor:pointer; outline:none; text-align:center !important;...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 and What_Id. FREQ (String): Defines the frequency of the reminder. The possible values are DAILY, WEEKLY, MONTHLY, YEARLY, NONE. If you specify, NONE, the system sets a one-time reminder and TRIGGER becomes mandatory. Action (String): Represents how you...

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

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

15 September 2009 last few lines with the original code (below) For this website template: I've added the module-dark 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...

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

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

03 June 2010 some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One solution was to untick "Simplify page headers" on the Excel Format Options when...

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 #efefef, , , White, =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"), "Black", "LightGray") BorderStyle: None, , , Solid, =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"), "Double", "Solid") BorderWidth: 1pt, , , ,...

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

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

29 March 2011 in all renderers" then I'd suggest you use method #1. Issues I ran into: I replaced the empty dataset with the message "None" using Method #2 above. I noticed when a textbox is hidden, the next textbox moves to fill up the space... There are some...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW:...

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

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 How? For Windows XP: Open an instance of Windows Explorer and click on "Tools" Select "Folder Options..." Select the "(NONE) Folder" option Click on "Advanced" Click on "New..." Enter the New Action as per the following: Action: - Give the action name a...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *