Unfortunately after logging into your demo website, no where could I find a "Laptop Catalog" example to see how it was done.
After trying for about 10 minutes to recreate it on my own, I gave up. If your product is this difficult to use, and your examples are lacking or completely missing, how are you selling to people with little to no knowledge of using Excel or spreadsheets?
Thank you for your interest in our plugin, and sorry you feel that way.
Our examples simply show what can be done with the plugin, and at the moment the only available tutorial is for the Cryptocurrency table. That tutorial can be found in our FAQ section.
Another tutorial which hasn't yet been published is for the Premier league table, and I can share it with you here:
This table is using the Aqua skin, with some modifications in the main settings. For instance, the surrounding borders are removed, and the table is automatically sorted in ascending fashion by the first column. There is no tutorial for the table in our documentation yet, so I'll just tell you here.
There is conditional formatting for the first "#" column:
Then, for the second column, the badges were taken from this link, and added in "String" type column in the following fashion. This is an example for Liverpool:
Now, the remaining columns are just integers, and the last one is the win/loss/draw column. It has a lot of conditional formatting applied to make it look like it does:
It goes all the way up to "20". And here's the rule for Liverpool again:
The plugin can do a lot, and please feel free to go through our documentation to get a better picture of what can be done with it. Unfortunately, you can't recreate the table like "Products Table" in 10 minutes, especially when you're not familiar with the plugin. These tables require at least basic knowledge of CSS, while all else can be done with built-in features of the plugin.
Please go through the two tutorials provided, and you should get an idea of how the other example tables are created. We'll create tutorials for all our example tables in the near future, and they'll all be in our FAQ section.
My initial comment was rude considering it's not your fault I don't have any spreadsheet knowledge. So I apologize for that.
I know HTML & CSS, so while I appreciate the time you took to outline some styles, it was not needed. What I'm looking to do seems rather simple - I have a product, let's say a t-shirt, but of different sizes and colors. All I want is a page on which someone can choose a t-shirt based on color + size = price. Nothing more. They select in one column the color, next column the size, next column shows price.
I'm guessing based on the complexity of some of your examples, this is possible, but I gotta ask anyways; can this be done with your plugin or should I be looking at a simpler solution? Maybe your plugin is overkill.
Almost there with all the crazy going on I finally got around to trying a new demo that seems to work based on your suggestions. However I ran into a filtering issue with numbers - when I create an item with a quantity value of 1, it filters okay, but when I add a value of 1000 it shows all rows with 1 and 1000. I tried with 2 and 2000, same result - it shows all results with 2 and 2000 items. So, it can't make a distinction between values with a single number and values with zeroes??? I gotta be missing something simple.
Can you see my demo, not sure how to share it? I titled it "T-SHIRTS."
Lastly, and I know at this point I'm bordering on a support-type question thread, I just want to make sure if I drop $200 or $400 it's because I at least understand the basics - - I kind of figured out cascading, but need to know if it is possible to hide all results from appearing until the final column value is selected?
For instance, the person chooses a T-shirt > Medium > Blue - then the table shows. Right now it wants to update all options based on every additional column value as soon as it is selected, so at some point (usually the first two columns) it's showing all the choices.
Have you configured that column to be an integer? It needs to be integer for numerical sorting and filtering to work properly.
Also, when you choose the filtering type, my advice is to enable Exact filtering, so the plugin looks for exact values in the column "1", "10", "100", "1000", etc.
If you meant on our sandbox site - I can't see that because the site refreshes every hour, on the 15th minute mark, so it's not saved.
We have a 15-day money back guarantee, so if you don't like the plugin, you can get a refund in that period of time.
As for the cascade filtering and hiding the table before filtering - those options are coming from our paid add-on Powerful Filters. There, you can choose to hide the table before filtering is applied; add a filter's Search button and disable that search button until all filters are selected. This would force your customers to first select all possible filters before the table is displayed:
Your product is a PITA for a product that otherwise looks easy to use.
I found an example close to what I need for a project (https://wpdatatables.com/documentation/table-examples/products-table/). Great!
Unfortunately after logging into your demo website, no where could I find a "Laptop Catalog" example to see how it was done.
After trying for about 10 minutes to recreate it on my own, I gave up. If your product is this difficult to use, and your examples are lacking or completely missing, how are you selling to people with little to no knowledge of using Excel or spreadsheets?
Hello Major Payne
Thank you for your interest in our plugin, and sorry you feel that way.
Our examples simply show what can be done with the plugin, and at the moment the only available tutorial is for the Cryptocurrency table. That tutorial can be found in our FAQ section.
Another tutorial which hasn't yet been published is for the Premier league table, and I can share it with you here:
This table is using the Aqua skin, with some modifications in the main settings. For instance, the surrounding borders are removed, and the table is automatically sorted in ascending fashion by the first column. There is no tutorial for the table in our documentation yet, so I'll just tell you here.
There is conditional formatting for the first "#" column:
And the custom CSS goes:
Then, for the second column, the badges were taken from this link, and added in "String" type column in the following fashion. This is an example for Liverpool:
So, the class "badge-1" and "badge-1.t1" classes are defined in Custom CSS:
The second class selects the position on the provided image where Liverpool's crest is located.
This is for all the clubs:
Now, the remaining columns are just integers, and the last one is the win/loss/draw column. It has a lot of conditional formatting applied to make it look like it does:
It goes all the way up to "20". And here's the rule for Liverpool again:
This changes from team to team. Everything else you may need is in the custom CSS:
That's about it. You will probably need to dig around all this to make it look exactly the same, but this is how it's done.
People who have little to no knowledge of Excel or spreadsheets can still create basic tables. You can add image columns, URL Link columns, Formula columns, apply different filters on the table, hide columns, use conditional formatting, and so on.
The plugin can do a lot, and please feel free to go through our documentation to get a better picture of what can be done with it. Unfortunately, you can't recreate the table like "Products Table" in 10 minutes, especially when you're not familiar with the plugin. These tables require at least basic knowledge of CSS, while all else can be done with built-in features of the plugin.
Please go through the two tutorials provided, and you should get an idea of how the other example tables are created. We'll create tutorials for all our example tables in the near future, and they'll all be in our FAQ section.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
My initial comment was rude considering it's not your fault I don't have any spreadsheet knowledge. So I apologize for that.
I know HTML & CSS, so while I appreciate the time you took to outline some styles, it was not needed. What I'm looking to do seems rather simple - I have a product, let's say a t-shirt, but of different sizes and colors. All I want is a page on which someone can choose a t-shirt based on color + size = price. Nothing more. They select in one column the color, next column the size, next column shows price.
I'm guessing based on the complexity of some of your examples, this is possible, but I gotta ask anyways; can this be done with your plugin or should I be looking at a simpler solution? Maybe your plugin is overkill.
Again, my apologies and thanks for your time.
No worries, Major Payne, I understand.
What you're looking for to achieve can be done like this:
You have a row for each t-shirt. Meaning, you have this:
Yellow | Size S | Price #1
Yellow | Size M | Price #2
Yellow | Size L | Price #3
Yellow | Size XL | Price #4
You get what I mean.
Then, you can enable filtering for those two columns with predefined values (see attachment).
If I was to remove the filtering values, I'd see the table with all values:
To remove any possibility of your customers clearing the filtering values, you can add this custom CSS:
This will cause the filters not to have the "empty" value:
So, your customers would only be able to choose the size and color. The rest of the data would be hidden.
I hope that helps.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Almost there with all the crazy going on I finally got around to trying a new demo that seems to work based on your suggestions. However I ran into a filtering issue with numbers - when I create an item with a quantity value of 1, it filters okay, but when I add a value of 1000 it shows all rows with 1 and 1000. I tried with 2 and 2000, same result - it shows all results with 2 and 2000 items. So, it can't make a distinction between values with a single number and values with zeroes??? I gotta be missing something simple.
Can you see my demo, not sure how to share it? I titled it "T-SHIRTS."
Again, thanks for your patience.
Lastly, and I know at this point I'm bordering on a support-type question thread, I just want to make sure if I drop $200 or $400 it's because I at least understand the basics - - I kind of figured out cascading, but need to know if it is possible to hide all results from appearing until the final column value is selected?
For instance, the person chooses a T-shirt > Medium > Blue - then the table shows. Right now it wants to update all options based on every additional column value as soon as it is selected, so at some point (usually the first two columns) it's showing all the choices.
Thanks.
Hi again Major Payne
Have you configured that column to be an integer? It needs to be integer for numerical sorting and filtering to work properly.
Also, when you choose the filtering type, my advice is to enable Exact filtering, so the plugin looks for exact values in the column "1", "10", "100", "1000", etc.
If you meant on our sandbox site - I can't see that because the site refreshes every hour, on the 15th minute mark, so it's not saved.
We have a 15-day money back guarantee, so if you don't like the plugin, you can get a refund in that period of time.
As for the cascade filtering and hiding the table before filtering - those options are coming from our paid add-on Powerful Filters. There, you can choose to hide the table before filtering is applied; add a filter's Search button and disable that search button until all filters are selected. This would force your customers to first select all possible filters before the table is displayed:
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables