Welcome to TT_tables
Just what the world needs right now, is yet another HTML table generator. Well here it is, and this one of course is special.
TT_tables is a 100% JavaScript solution, that takes CSV data, in various forms, or DB query results and
display them in a tabular form. Advantages of TT_tables include:
- It's 100% free and has no third party dependencies or plugins required
- 100% client side javascript. Be nice to your servers, just provide the data, TT_tables will do the rest
- It's not about the raw data but rather the finer points of presentation:
- Different table types
|
|
|
- Group by field
- Group by first letter of field
|
- Virtual fields to round out useability
- Rule based filters based on column values
- Include / exclude rows
- (e.g) Exclude this row from report if value of column ABC is less than 100
- Conditional formating (styles) on cells and rows
- (e.g) Make cell ABC flash in red if value is between 100 and 200
- Conditional values
- (e.g) Make the image of virtual field this logo.png if value of ABC contains "acme"
- Customizable with JS callbacks
- On cell or row click
- On column right click
- On expand (with virtual expand / collapse field)
- Easy to use with built in intuative GUI interface to define table views
- Create multiple views of the same data. Get data once display in multiple ways
- On the fly CSS. Let TT_tables deal with the intricacies
TT_tables Features
There are too many features to list all of them here, but some of the more interesting features include:
-
An intuitive table builder that allow you to build the look and feel of the table in a responsive web environnent
Make and then see your changes quickly
-
Build multiple views for data set to view same data in different ways such as (e.g.) group employee list by department,
and/or last name, ... etc. all without having to go back to server/DB to re-get data
-
Multiple table types including:
-
Flat list, with view port technology to dynamically only show rows needed. Very important for when dealing with
large data sets as the rendering of HTML, even if it's hidden, takes the most time.
-
Group by field or by first letter of field,
-
Paginated. You pick the page size
-
25+ different field types including virtual fields
| The Basics | The Special | The Virtual |
|---|
- As is text
- All upper case
- All lower case
- Proper name
- Unformated number
- Formated number
- Currency
- Percentage
|
| >
- Date and time (various input/output formats)
- Email address
- Phone number
- Image
- URL
|
- Index (row enumeration)
- Empty field
- Menu
- Collapse / uncollapse
- Various checkbox types
- Static text, numbers, and images
- Vertical seperator
- Math fields. SUM, AVERGAGE, MINIMUM,
MAXIMUM, ABSOLUTE VALUE
|
- On click support to own functions including click reference fields (e.g) email icon refering to (possibly hidden) email address.
-
On the fly CSS. Select via the GUI interface
-
Cell style
- Font name
- Font size
- Font colour
- Background colour
- Text decorations
|
| >
- Character spacing
- Leader
- Overflow behaviour
- Vertical alignment
|
-
Cell width which includes left and right pading settings
- Fixed width
- Dynamic width as function of % of total width with min and max values
- Dynamic width as function of % of total unused space with min and max values
-
Row height
- Advanced search abilities
-
Create rules to affect behaviour
- Include / exclude rows based on criteria
- Apply a style (color / font / size / ...) to a row or cell based on criteria
- Determine the stating state of a checkbox based on criteria
-
The usual sort on columns
- Multi level sort
- Limit which columns can be sorted on
- Disallow user sorting
- Advanced search capabilities, including selecting which columns to search and the weighing of columns
- It's small. Runtime compressed dowload size of ~70KB