Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #2339590
Examples
Closed

Comments

  • Major Payne started the conversation

    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?

  •  2,498
    Aleksandar replied

    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:

    3817908154.png

    And the custom CSS goes:

    .wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd:hover td{
    background-color:#fffbf1 !important;
    }
    .wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd td.grey,
    .wpdt-c .wpDataTablesWrapper table.wpDataTable td.grey{
    background-color: #dcdcdc !important;
    border-left: 1px solid #dcdcdc !important;
    }
    .wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd td.blue,
    .wpdt-c .wpDataTablesWrapper table.wpDataTable td.blue{
    background-color: #0083c2 !important;
    border-left: 1px solid #0083c2 !important;
    }
    .wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd td.red,
    .wpdt-c .wpDataTablesWrapper table.wpDataTable td.red{
    background-color: #d6181f !important;
    border-left: 1px solid #d6181f !important;
    }
    .wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd td.lightblue,
    .wpdt-c .wpDataTablesWrapper table.wpDataTable td.lightblue{
    background-color: rgb(91,192,222) !important;
    border-left: 1px solid rgb(91,192,222) !important;
    }
    .white-text {
     color: #fff !important;
    }
    

    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:

    <span class="badge-1 t1"><a href="https://www.liverpoolfc.com/welcome-to-liverpool-fc">Liverpool</a></span>
    

    So, the class "badge-1" and "badge-1.t1" classes are defined in Custom CSS:

    .badge-1 {
        background-image: url(https://wpdatatables.com/wp-content/uploads/2018/12/badges-25-sprite.png);
        background-repeat: no-repeat;
        width: 25px;
        height: 25px;
        display: block;
        background-position: -50px -350px;
        display: inline-block;
        vertical-align: middle;
        margin-right: .5rem;
    }
    .badge-1.t1 {
        background-position: -250px -225px;
    }

    The second class selects the position on the provided image where Liverpool's crest is located.

    This is for all the clubs:

    .badge-1.t1 {    background-position: -250px -225px;
    }
    .badge-1.t2 {    background-position: -250px -250px;
    }
    .badge-1.t3 {    background-position: -275px -325px;
    }
    .badge-1.t4 {    background-position: -150px -150px;
    }
    .badge-1.t5{        background-position: 0 -50px;
    }
    .badge-1.t6{    background-position: -275px -200px;
    }
    .badge-1.t7 {      background-position: -350px -75px;
    }
    .badge-1.t8 {    background-position: -50px -125px;
    }
    .badge-1.t9 {    background-position: -250px -125px;
    }
    .badge-1.t10 {    background-position: -350px -250px;
    }
    .badge-1.t11 {    background-position: 0 -200px;
    }
    .badge-1.t12 {        background-position: -350px -125px;
    }
    .badge-1.t13 {    background-position: -100px -100px;
    }
    .badge-1.t14{        background-position: -50px -175px;
    }
    .badge-1.t15 {    background-position: -250px -225px;
    }
    .badge-1.t16 {    background-position: -325px -250px;
    }
    .badge-1.t17 {    background-position: -75px -150px;
    }
    .badge-1.t18 {    background-position: -25px -150px;
    }
    .badge-1.t19 {        background-position: -75px -225px;
    }
    .badge-1.t20 {    background-position: -225px -100px;    }
    

    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:

    5368329923.png

    It goes all the way up to "20". And here's the rule for Liverpool again:

    <div class="score-last-6">
    <span class="score-last-one win"></span>
    <span class="score-last-one win"></span>
    <span class="score-last-one win"></span>
    <span class="score-last-one win"></span>
    <span class="score-last-one win"></span>
    <span class="score-last-one win"></span>
    </div>
    

    This changes from team to team. Everything else you may need is in the custom CSS:

    .score-last-6 {
        margin:0 auto;
        border-collapse: separate;
        display: table;
        border-spacing: 3px 0;
    height:11px;
    vertical-align: middle;
    }
    .score-last-one{
        display: table-cell;
        height: .7em;
        width: .7em;
    }
    .win {background: #0083c2;}
    .lose{background: #d6181f;}
    .equal {background: #dcdcdc;}
    

    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 columnsURL Link columnsFormula 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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • Major Payne replied

    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.

  •  2,498
    Aleksandar replied

    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:

    5562475726.png

    To remove any possibility of your customers clearing the filtering values, you can add this custom CSS:

    #table_1_1_filter > span > div > div > ul > li:nth-child(1),
    #table_1_2_filter > span > div > div > ul > li:nth-child(1) {
    display: none !important;
    }
    

    This will cause the filters not to have the "empty" value:

    9984305133.png

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • Major Payne replied

    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.

  • Major Payne replied

    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.

  •  2,498
    Aleksandar replied

    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:

    4515249570.png

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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