Absolutely love working with Datatables, and the support is brilliant. So glad I chose this path now, as I was considering AG-Grid for a while, but it was very lacking in documentation (I'm not knocking it, it looks fab, but by it's very nature of being 'Agnostic' as they put it, the learning curve looked very steep). I use Datatables in 2 different environments. The first is to act as a search tool for our Magento store https://www.wardgemstones.com/stonefinder/ Magento is great, but it doesn't do search very well out of the box. With over 30,000 products we needed customers to be able to find stock quickly, and with State Save the grid is exactly as it was when they left it, which makes it pleasant to use as a search tool. I'm currently feeding Datatables with a separate database, which is a pain as I have to keep it up to date, but I am looking at generating a feed automatically from Magento for DT to work from.
The 2nd usage is as a private price list for staff to use. It has around 60,000 products in it, and is great for eradicating duplicate SKU code issues and moving away from using Excel as a price list, which is pretty cumbersome. This is very much a work in progress with additional elements being added over the coming months. I will be linking in an inventory system, adding a postage system (using the Royal Mail API), and designing a system to deal with products that are out on approval. Plenty to keep me busy! Thanks for all the support from the forums, and thanks especially to Allan for all his hard work and patience, it's very much appreciated, especially from someone like me who always seems to be a little bit out of their depth!
Yes, mobile view is an issue. It's currently not visible to mobile devices (unless you have the link!). I'm going to look at the 'card' layout that I've seen discussed on here for mobile. I know there is the responsive option in DT but a card layout lends itself better to mobiles IMO.
Not entirely sure why the cells behave in that way going from landscape to portrait.
I am using Datatables Editor PHP with Laravel to rewrite my webapp which manage marketing projects of any type, exporting/connecting to many objectives (TV Indoor, site, e-Commerce, Social Network, mobile apps, Adobe InDesign catalogs and magazines, etc). Here is how it is looking at the moment hahahaahu
I am using the javascript version. DataTables is the most preferably plugin for my client's Employee's Quote calculator (the very existence of the system ) - can sort (drag & drop) specific columns, scroll bar at the bottom for overflow columns and setting the first 3 columns as fixed.
I am developing an interface for keeping track of products that we sell in Amazon, Ebay and as such marketplaces. It's integrated with their APIs. So for example when I post a product in our interface, it updates marketplaces live.
I have used DataTables library some times ago in many projects (some were simple ,some were complex enough ) which have been implemented with php. The library had worked perfectly. The library has been functional. All had been good. Nowadays, i want to include datatables library in a project which is going to be implemented with asp.net and i need to implement DataTables server side in most cases. I hope that DataTables library is going to function properly
Naming conventions
Before we move on, it’s useful to understand the conventions used in the library. DataTables uses Hungarian notation for naming variables, which basically adds certain prefix to its name that helps to understand type of data held by the variable.
n – Variable represents a node.
o – Variable represents an object.
a – Variable represents an array.
s – variable is a string.
b – Boolean
f – Float
i – Variable holds an integer value.
fn – Variable represents a function.
Sometimes you will see multiple prefixes used together, like ao, which represents an array of objects.
Turn of paging and show all crashes drupal 8 as it takes me to "drupal is already installed" I have 6000 entries. I need to set it to server side processing, the drupal module doesn't allow that. So it is pretty useless as you can only sort what is on the page and search for what is on the page if you use drupal's paging.
I am using Data tables for displaying aggregated information from different databases and I am rendering almost 10000 rows. The Django based application is not still complete. So, I can not post links/screen-shots.
We're currently developing a hosted application for visualisation and filtering of measured values captured from various industrial equipment on top of the grails framework with JQuery and JQuery-UI, powered by a MySQL Database.
I'm using it for a free karaoke song database that karaoke DJs can use to find out whether songs have been released and whether or not they're currently available from any of the major vendors to purchase and download.
I started using datatables about four years ago. Initially I just adopted a basic setup, but quickly realized the great potential and learned to integrate more of the extensions, especially the editor extension. Nowadays any large table that requires sorting, filtering or editing, my preferred tool is using datatables.
The applications I build are primarily developed for non-profit health care or public health organizations with the need to organize data, summarize data in meaningful ways and share this data with their respective audiences. Most of these applications are access protected due to the nature of the data that is collected.
One public facing site is https://californiacardiacsurgery.com which is one of the earlier uses of datatables (and sadly we are still waiting for the next round of data to update the site).
The most recent project I have been working on uses datatables to support a comprehensive on-line help system for several of the databases collected. Users are able to review and edit context-sensitive help information for each field collected (using the editor extension, tinymce plug-in, fixed header extension and others), add comments, compile a manual for dissemination among participants, and manage help library versions. The database built is also used when data base users request help for a specific field when entering data.
I learn more about datatables each time I am using it, and I often feel that I am still only scratching on the surface of what you have put at our finger tips!
Changed jobs and as soon as a web development project was on my desk I was persuading my boss to buy me a DataTables Editor license (I've been given the trial period to show him how awesome it is).
I'm working on a rapid deployment for an industrial site management and device analytics system with DataTables+PHP, to replace a 110,000 line long vb.net program that I can only describe as a spaghetti monster!
I wanted to share some screen shots of some of the things I built in DataTables
They all have Editor and multi-field Bubble-editing. Some contain nested datatables inside the row-details of a datatable. I have done a lot of cool things I could never possibly do without DataTables. Thanks Allan.
I've just changed all my tables to use it on my local sports league website. It's so great. Only using the default styling, which works fine for me - although I do like some of the styles I've seen in this thread.
The most important use is league tables and individual players averages (obviously unsortable):
But then fixture lists are good for it too, some of which make use of searching, sorting and rowGroup:
It has also enabled me to make my new reports section quite interactive; we have a rule that allows players to "play up" (or play on loan) a limited number of times from another division. I have managed to make a report showing who's played up, when, for whom and against whom:
But as well as sorting and searching, I've used a select list to allow people to group by one of the fields. This detects a change in the select list, sets the selected column visibility to false and groups by that column, showing the number of rows in the header. Once a different column (or no column) is selected, that column's visibility is set back to true:
I've used DataTables and Editor for a side project to build a content management system for events. Users create and edit content using a web interface, upload the event content to the cloud, and then access it via my mobile app Event Truly.
I'm using Datatables and Editor JS on the client side, and Editor PHP with mysql on the server side. Everything is styled using Bootstrap 4 styling.
Here are a few screen shots with a few key DataTables and/or Editor features noted:
This is the main table for event content. Each tab (Summary/Category/Date/etc) has a unique Datable on it. Within the table shown, rows are grouped, and can be reordered (which affects menu order when content is shown in mobile app). Some columns are sortable, and some columns support inline editing. Also, all tables offer the column visibility option, and the ability to export the data. Many tables support import CSV data to bulk load information.
The following table is where unique activities at an event can be defined. Each table also supports varying the number of rows displayed, along with search within the table. This image also shows the Editor's autofill feature in use, where a value in one cell can be copied to one or more other cells. Autofill works with text, numbers, and image fields. (When used with image fields, it's a great way to upload a single image, but share it across multiple rows.)
This next image shows two tables that utilize a parent/child relationship. Selecting a row in the Schedule table, displays one or more child rows in the Time table.
Finally, here is an image of editing a Schedule row, and making use of the moment.js date time control (included with the Editor).
Overall, the site has more than 70 tables and associated editors. It's been great fun learning and coding to the DataTables and Editor APIs. The support and documentation that Allan, Colin, and team have provided is outstanding.
If you'd like to visit my Event content management system site, it is located at EventTruly.com.
Replies
Absolutely love working with Datatables, and the support is brilliant. So glad I chose this path now, as I was considering AG-Grid for a while, but it was very lacking in documentation (I'm not knocking it, it looks fab, but by it's very nature of being 'Agnostic' as they put it, the learning curve looked very steep). I use Datatables in 2 different environments. The first is to act as a search tool for our Magento store https://www.wardgemstones.com/stonefinder/ Magento is great, but it doesn't do search very well out of the box. With over 30,000 products we needed customers to be able to find stock quickly, and with State Save the grid is exactly as it was when they left it, which makes it pleasant to use as a search tool. I'm currently feeding Datatables with a separate database, which is a pain as I have to keep it up to date, but I am looking at generating a feed automatically from Magento for DT to work from.
The 2nd usage is as a private price list for staff to use. It has around 60,000 products in it, and is great for eradicating duplicate SKU code issues and moving away from using Excel as a price list, which is pretty cumbersome. This is very much a work in progress with additional elements being added over the coming months. I will be linking in an inventory system, adding a postage system (using the Royal Mail API), and designing a system to deal with products that are out on approval. Plenty to keep me busy! Thanks for all the support from the forums, and thanks especially to Allan for all his hard work and patience, it's very much appreciated, especially from someone like me who always seems to be a little bit out of their depth!
Hi karlie
Just tested on Iphone all works well.
However if I go from portrait to landscape and back the cells don’t resize until I click reset button
Add your reset code on orientation change
Cheers
Steve Warby
Yes, mobile view is an issue. It's currently not visible to mobile devices (unless you have the link!). I'm going to look at the 'card' layout that I've seen discussed on here for mobile. I know there is the responsive option in DT but a card layout lends itself better to mobiles IMO.
Not entirely sure why the cells behave in that way going from landscape to portrait.
Follow my blog post where I explain how datatables is used with node and express and mongodb .
https://medium.com/@deepika.gunda/series-datatables-with-nodejs-express-and-mongodb-part1-get-a-database-to-work-with-7ce78848023e
I am using Datatables Editor PHP with Laravel to rewrite my webapp which manage marketing projects of any type, exporting/connecting to many objectives (TV Indoor, site, e-Commerce, Social Network, mobile apps, Adobe InDesign catalogs and magazines, etc). Here is how it is looking at the moment hahahaahu
Hi Allan,
I am using the javascript version. DataTables is the most preferably plugin for my client's Employee's Quote calculator (the very existence of the system ) - can sort (drag & drop) specific columns, scroll bar at the bottom for overflow columns and setting the first 3 columns as fixed.
Thanks!
Daisy
I'm newbie and using datatables with angular 5
I want search example with angular but diffcult !
Thanks !
I am developing an interface for keeping track of products that we sell in Amazon, Ebay and as such marketplaces. It's integrated with their APIs. So for example when I post a product in our interface, it updates marketplaces live.
I have used DataTables library some times ago in many projects (some were simple ,some were complex enough ) which have been implemented with php. The library had worked perfectly. The library has been functional. All had been good. Nowadays, i want to include datatables library in a project which is going to be implemented with asp.net and i need to implement DataTables server side in most cases. I hope that DataTables library is going to function properly
I am creating a price list, with dynamic columns, depending on the type of price given to a customer.
Naming conventions
Before we move on, it’s useful to understand the conventions used in the library. DataTables uses Hungarian notation for naming variables, which basically adds certain prefix to its name that helps to understand type of data held by the variable.
n – Variable represents a node.
o – Variable represents an object.
a – Variable represents an array.
s – variable is a string.
b – Boolean
f – Float
i – Variable holds an integer value.
fn – Variable represents a function.
Sometimes you will see multiple prefixes used together, like ao, which represents an array of objects.
Im using it to update a courier delivery site and was even able find a way to include google maps api when viewing orders.
Allan Bhai - Brother in our language..... data translation...haha, I am building a system to show datagrids in Tabs.
Turn of paging and show all crashes drupal 8 as it takes me to "drupal is already installed"
I have 6000 entries. I need to set it to server side processing, the drupal module doesn't allow that. So it is pretty useless as you can only sort what is on the page and search for what is on the page if you use drupal's paging.
I am using Data tables for displaying aggregated information from different databases and I am rendering almost 10000 rows. The Django based application is not still complete. So, I can not post links/screen-shots.
livescore
We're currently developing a hosted application for visualisation and filtering of measured values captured from various industrial equipment on top of the grails framework with JQuery and JQuery-UI, powered by a MySQL Database.
https://cambosports24.com
I have 12 datatables:
I need to display datatables with export and visibility buttons.
This is the datatables-init.js file
The buttons do not display, I know that this is a problem with the place where they are displayed. Can anyone help ?
I need help with this : https://datatables.net/forums/discussion/55092/can-we-convert-the-filter-option-to-a-drop-down-option-list/p1?new=1)
That's my plan of using DataTables . Can you please help me guys ?
Hey Allan,
I use it to update my parse Dashboard database, if it finally works
I'm using it for a free karaoke song database that karaoke DJs can use to find out whether songs have been released and whether or not they're currently available from any of the major vendors to purchase and download.
https://db.openkj.org
hi admin, thank for all. am learn with your datatable. thanks for all
I use DataTables to build a Pharmacy Management Application for the hospital where I work.
very simple application that I made,
but maybe the benefits are more needed. like datatables, simple syntax creates magic tables.
thankyou @allan
I started using datatables about four years ago. Initially I just adopted a basic setup, but quickly realized the great potential and learned to integrate more of the extensions, especially the editor extension. Nowadays any large table that requires sorting, filtering or editing, my preferred tool is using datatables.
The applications I build are primarily developed for non-profit health care or public health organizations with the need to organize data, summarize data in meaningful ways and share this data with their respective audiences. Most of these applications are access protected due to the nature of the data that is collected.
One public facing site is https://californiacardiacsurgery.com which is one of the earlier uses of datatables (and sadly we are still waiting for the next round of data to update the site).
The most recent project I have been working on uses datatables to support a comprehensive on-line help system for several of the databases collected. Users are able to review and edit context-sensitive help information for each field collected (using the editor extension, tinymce plug-in, fixed header extension and others), add comments, compile a manual for dissemination among participants, and manage help library versions. The database built is also used when data base users request help for a specific field when entering data.
I learn more about datatables each time I am using it, and I often feel that I am still only scratching on the surface of what you have put at our finger tips!
I mainly use Datatables through the R package DT. Some examples of what I've done are given in my blog here and here.
Hello Again!
Changed jobs and as soon as a web development project was on my desk I was persuading my boss to buy me a DataTables Editor license (I've been given the trial period to show him how awesome it is).
I'm working on a rapid deployment for an industrial site management and device analytics system with DataTables+PHP, to replace a 110,000 line long vb.net program that I can only describe as a spaghetti monster!
See you in the discussions,
David
Here is my project that uses DataTables. JukeBox
I wanted to share some screen shots of some of the things I built in DataTables
They all have Editor and multi-field Bubble-editing. Some contain nested datatables inside the row-details of a datatable. I have done a lot of cool things I could never possibly do without DataTables. Thanks Allan.
I've just changed all my tables to use it on my local sports league website. It's so great. Only using the default styling, which works fine for me - although I do like some of the styles I've seen in this thread.
The most important use is league tables and individual players averages (obviously unsortable):
But then fixture lists are good for it too, some of which make use of searching, sorting and rowGroup:
It has also enabled me to make my new reports section quite interactive; we have a rule that allows players to "play up" (or play on loan) a limited number of times from another division. I have managed to make a report showing who's played up, when, for whom and against whom:
But as well as sorting and searching, I've used a select list to allow people to group by one of the fields. This detects a change in the select list, sets the selected column visibility to false and groups by that column, showing the number of rows in the header. Once a different column (or no column) is selected, that column's visibility is set back to true:
It's a fantastic tool, thanks so much.
I've used DataTables and Editor for a side project to build a content management system for events. Users create and edit content using a web interface, upload the event content to the cloud, and then access it via my mobile app Event Truly.
I'm using Datatables and Editor JS on the client side, and Editor PHP with mysql on the server side. Everything is styled using Bootstrap 4 styling.
Here are a few screen shots with a few key DataTables and/or Editor features noted:
This is the main table for event content. Each tab (Summary/Category/Date/etc) has a unique Datable on it. Within the table shown, rows are grouped, and can be reordered (which affects menu order when content is shown in mobile app). Some columns are sortable, and some columns support inline editing. Also, all tables offer the column visibility option, and the ability to export the data. Many tables support import CSV data to bulk load information.
The following table is where unique activities at an event can be defined. Each table also supports varying the number of rows displayed, along with search within the table. This image also shows the Editor's autofill feature in use, where a value in one cell can be copied to one or more other cells. Autofill works with text, numbers, and image fields. (When used with image fields, it's a great way to upload a single image, but share it across multiple rows.)
This next image shows two tables that utilize a parent/child relationship. Selecting a row in the Schedule table, displays one or more child rows in the Time table.
Finally, here is an image of editing a Schedule row, and making use of the moment.js date time control (included with the Editor).
Overall, the site has more than 70 tables and associated editors. It's been great fun learning and coding to the DataTables and Editor APIs. The support and documentation that Allan, Colin, and team have provided is outstanding.
If you'd like to visit my Event content management system site, it is located at EventTruly.com.