Advanced Grid gives you the ability to display Data Tables as in Excel.
Create interactive data tables using sorting, searching, pagination, filtering and more. This plugin is really easy for beginners.
There are several ways of functional and visual customization of the tables.
Features:
Columns can be switched places with drag and drop + the width of the columns can be controlled
Different ways of searching
You can save tables in Excel, PDF and CSV
You can also send it to print
Add, Edit and remove lines
Pagination + you can control the amount of pages that should be shown
In my case, the number of ROWS is preset to show only 10. Regardless of how many are set to be viewable, only 10 show. You must scroll to see all the rows. Changing the number of rows visible affects only the pagination, not the number of rows the user can actually see at one time.
I’m actually talking about rows and not columns. Limiting to 10 columns is a problem when looking at large data sets, but It is more forgiving then 10 rows. Having only 10 rows makes it unusable for looking at user data since it would require too much scrolling from the end-user.
As for the 2nd question, we use several dropdowns to filter repeating groups for the end-user. This lets them pull their own custom reports. I could see any filtering options when using your plugin.
I don’t want it to seem like I’m negative! In fact, I think you are on to an awesome idea!! Just need some refinement.
That does and it is one of the main issues I had. I think it is a really cool idea that solves many problems. I’m just seeing some issues with usability like the row scrolling.
I would also like to see mixing of data types in the future. I was able to get search to work within the table even though I can do it in repeating groups.
You have an interesting side plugin in your application , which changes all the elements in the table. This plugin add a css code to the page with this:
table, th, td {
border: 1px solid black !important;
width: 40px !important;
}
On the page which you show as a demo you also have the Air Date/Time Picker and it also has some issues. It has a black grid and is moved to the left.
If you remove this css code then the table elements work perfectly fine, both the Advanced Grid and Air Date/Time Picker.
For example see the Address table. The vendor fields type refers to the Vendor table. Will it be possible for the Vendor to show up in the table I create?
You were asking about if there are two database tables will they be visible both.
We’ve decided to add an additional table into the database and called it Vendor just for you.
In the Vendor Table there are two different fields - text (VendorName) и number (VendorPID)
Everything is connected and working. You can preview everything on the demo page From there you can go to the bubble editor and see how it is all connected in the Data tab – Identity and Vendor tables.
Hope we could be of help.
