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

22 October 2021 Creator form and instead of scrolling down while entering data, they would prefer if they could have tabs along the top to display each section. How? The way we do this is by applying our own stylesheet and overriding certain CSS elements that the...

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

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 So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This is written at a time when Javascript or interactive pages that...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 ChangeLogOptions3.1.1 Artur- Enhancement: Added parameter: Weblink separator height. - Enhancement: Added parameter: Display submitted by. - Enhancement: Added parameter: Display category. - Enhancement: Reorganized parameters "Module Settings". -...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....

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

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

14 October 2024 span{padding:0 !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: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling...

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular report (which searches for results matching the...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 need to build an app similar to the file explorer in the Microsoft Windows OS. Why? I had an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general. How? So first I'm going to list a...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind of things...

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

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 This is an example of Javascript code to update and display the elapsed/remaining hours minutes and seconds in real-time. Why? I know there are a lot of articles out there that write about the same, but this is an example that I was coding and found to...

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

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 reference fields in the template before Zoho advised on a 'hidden' away setting which was key to changing what these display. What I had: ${CONTACT.CONTACT_DISPLAYNAME} ${CONTACT.CONTACT_ADDRESS} ${CONTACT.CONTACT_CITY} ${CONTACT.CONTACT_CODE}...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 Type" > select under Data Type: "URL" Right-click on the "Image URL" column again and select "Format Column" > Select under Display As: "Image" You can now specify the size of the image as well (16x16 is a tad small). Caveat(s): A bit work needs to be...

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

Display a thumbnail of a Google Drive videohttps://www.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 file id The shareable link to the file will be something like: https://drive.google.com/file/d//view?usp=sharing // to link/display in apps: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // redirects to something like:...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 --- Category Title --- Category Parent --- Create Date / Modified Date / Expired Date --- Order by / Order az --- Display all reviews/comments (or just for this version) --- Display/Access based on User level - Added Admin Section: Manage Projects (each...

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

SSRS Display question mark when date is blankhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field. Why?...

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

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 dxdiag Disk Cleanup Utility cleanmgr Disk Defragment dfrg.msc Disk Management diskmgmt.msc Disk Partition Manager diskpart Display Properties control desktop Display Properties desk.cpl Display Properties (w/Appearance Tab Preselected) control color Dr....

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 confusing. When I wrote the support documentation which makes use of this little trick for my managers, I explained it as displayed in the following image (apologies for the image but it's still clear as mud in my head): Oracle SQL*Plus Only for...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00...

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

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

MySQL Commands to display all columnshttps://www.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY...

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