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 #2389826
Filter which columns to show
Closed

Comments

  • Marcial Bollinger started the conversation

    Hi there

    I have a table with hotels as columns and weeks as rows. The prices for each combination are in the cells. 

                        Hotel 1          Hotel 2          Hotel 3

    Week 1        123                 234                345

    Week 2        987                 876                765

    Week 3        555                 444                333

    I'd like to show a table for each hotel. For that I need to hide the columns of all other hotels. Is it possible to do that dynamically, e. g. by adjusting the shortcode or adding some simple code?

    If that's not possible, the only way to achieve that would be to create multiple wpDataTables with the same master file as source, but each wpDataTable with different hidden columns, right?

    Thanks for your help.

  •  471
    Isidora replied

    Hi Marcial,
    Thank you for your purchase.

    Yes you can do that manually by creating more tables and hiding columns that you dont need. At the moment you can not do it dynamically with columns, but if is possible to convert that table so you can create table that hotels will be in one column and column header to be weeks like this

     Hotels         Week 1          Week 2          Week 3

    Hotel 1        123                 234                345

    Hotel 2        987                 876                765

    Hotel 3        555                 444                333

    Then you will import that file with third option in our table wizard and you will create manual table. After this will be created MySQL tables in database like wp_wpdatatable_1 which you can use for creating table from MySQL and placeholders like this

    SELECT * FROM wp_wpdatatable_1 WHERE hotels=%VAR1%

    For backend preview you will provide some value for VAR1 to table generation. On Front, you will pass in var1 in shortcode that you need so like this you will have one table and you can show it in different views on other pages like this

    [wpdatatable id1 var1="Hotel 1"] 

    then on other page

    [wpdatatable id1 var1=" Hotel 2"]

    You can check out more about placeholders here.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  • Marcial Bollinger replied

    Hi Milan

    Thanks a lot for your reply. Changing the format might be an option. I know about the placeholders. That could be a good solution, but from a usability perspective, it might be no very intuitive to have the timeline horizontal. 

    I'll discuss this with my team and let you know in case we need more help or have a update for you. Thanks again!

  •  2,498
    Aleksandar replied

    Hi Marcial

    I'm glad to hear Milan's suggestion will help you out with this.

    Please let us know if there's anything else we can do for you.

    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