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 #3488339
Hide Empty Columns?
Closed

Comments

  • Keoni started the conversation

    I am about to purchase but I have a couple questions on if it's possible.

    Is it possible to auto-hide a column with no entries?  I am also using Formidable forms as well.  

    I have an entry of age groups where they are all listed but would like the table to build from the ones that have entries only and not all 12 age groups, unless there are entries in all of them.

  •  1,692
    Miloš replied

    Hi Keoni,

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    Yes, you can achieve this with our Conditional Formatting feature.

    You can set a rule, if any of the cells are empty - then hide the column.

    For example, if i do this on my table here, at first i have a lot of values in this Column "name",

    6484931126.png

    I will set this Condition,  if any cell value becomes empty, then add a CSS class to that Column of "hide".

    "hide" is a pre-made CSS class that basically visually hides elements.

    3532278937.png

    Then if i edit any cell in this column, set it as empty - the entire column will hide.

    5151682117.png

    So if i understood, this should work in your use-case,

    just to show it if all the Column rows have Entries - otherwise if there is any entry cell to hide it?

    -

    The same method can be used for any of our Tables, as well as Tables connected with a Formidable Form as data source.


    Please note :

    Formidable Forms integration for wpDataTables is an add-on that requires premium (full) versions of both wpDataTables and Formidable Forms plugins, 

    They need to be installed and activated on your WordPress website in order for this add-on to work.

    Please check more about this integration here;

    Before purchase you can test all plugin and Add-on features on our sandbox site.

    You will find other Demo links for all add-ons in my Signature, if you wish to try them out.

    And i just wanted to point out that

    there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Let me know if you have any additional questions. smile.png

    Kind Regards, 

    Miloš Jovanović
    [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

  • Keoni replied

    Thank you for your help. 

    It almost works but not exactly.  So have a bunch of columns that I only want them to show, if they have entries.  I notice this way, if one entry is blank then the whole column hides.  So I need it the other way around.  Is there a "show" css?  that if one entry is not blank then show the column?


  • Keoni replied

    So technically, the entire table would be hidden, until someone put input in the form fields.  then the table would show the columns that actually have input on them.

  • Keoni replied

    testing another table as well. this one I would like to hide the column when ALL the cells in that column are empty. Not just one of them. 

  •  1,692
    Miloš replied

    Hi Keoni,

    I would like to extend my heartfelt apologies for the delay in our response. We have recently experienced a higher volume of tickets than usual, which has regrettably caused this delay. Your understanding and patience during this time are greatly valued and appreciated.

    -

    This is a bit more complex use-case, so i am not sure if we have an ideal solution for both of the cases, at the moment,

    we will check if we have any workaround to offer, and going to report back as soon as possible.

    Thank you for your patience.

    Kind Regards, 

    Miloš Jovanović
    [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

  • Keoni replied

    thank you for your response. 

    I realized if there would be some way to have the conditional filter have

    If ALL cells are empty then add css column hide that would work I think for all my tables. It may be more work to implement but keep me posted. 

    I’m not even sure if there is a code hook to do it. I tried to search but found nothing. 

    Thank you for looking into a solution

    Keoni

  •  1,692
    Miloš replied

    Hi Keoni,

    I checked for any available workaround, and sorry to disappoint you,

    but we do not have a way to set a Condition that checks in case if all the cells are empty.


    So, we can either say " if any cell is empty",

    or if a cell "contains" some value,

    or it "does not contain" some value.


    But we do not have a possible Condition at the moment that can check if "all cells are empty" then hide the entire column.


    That is an interesting idea for a future option, though.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.


    Kind Regards, 

    Miloš Jovanović
    [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

  • Keoni replied

    Hi Milos,

    thank you for trying and checking.  I may have to request a refund for now.  I will check back and see if this makes in there some day.

  •  1,692
    Miloš replied

    Hi Keoni,

    My apologies, please disregard what i sent as the original Reply,

    deleted it and sent a new one, i actually think i have a good idea what could be a solution for your use-case.

    In our Conditional Formatting Logic, we can add several Rules, and each "next rule" has higher priority over the previous Rule.

    So, let's say if you set the first Rule to check, if there is any empty Column,

     to add a CSS class to the Column, which will do a custom CSS code to set "display" as "none" to that Column.

    But then, add another Rule beneath it, that adds a new CSS class if any cell is not blank,

    and on this CSS we say set the Display of that Column to : table-cell. ( which is the original/default display property)

    I made a Test on my Table and happy to say, it seems to work exactly as intended.

    -

    Here is my example in more details. If i add this Column, just named it "Empty Column", then i first make all cells empty to see if it hides it, and it does.

    Then, if i add just one cell with some Data, then the Column is shown.

    1414469425.png

    I did these two Rules in that Column :

    3333307823.png

    In my case, i name the one that hides "hidecustom" and the other Class that shows ( if there is any cell which is not empty)  as "showcustom".

    Then, add this CSS to the Customize/Custom CSS of the Table :

    .hidecustom {
        display : none;
    }
    .showcustom {
        display: table-cell !important;
    }
    
    8519459934.png

    ( Of course, you can rename the classes anything you wish)

    So, it works because the 'second' rule has more importance/overrides the first rule.

    The same logic applies to setting CSS lines, it is always the last line that has priority over the 'older lines above', so i think this should work for your use-case.smile.png

    Please try it if you can and let me know how it goes.

    I hope you still did not start a refund process.

    Thank you again for your patience, i realise this took me a lot longer than it should, took a lot of testing and brainstorming, so to speak, before i figured it out.

    Kind Regards, 

    Miloš Jovanović
    [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

  • Keoni replied

    Hi Milos,

    This is AWESOME! I already got my refund but I will gladly purchase again as this is a key factor in my tables!  Thank you so much.  I do have a couple other things I'm trying to do as well.  I tried it on the sandbox, but I couldn't get it.  I may create a separate ticket as it's another thing.

    Thank you so much

    Keoni

  •  1,692
    Miloš replied

    Hi Keoni,

    I am happy to see this helps, at least with this major point of your use-case.

    As you can see, i tested this method on a couple of Tables, so it should definitely work without any issue.

    No problem at all, you can check if you have enough features working for the use-case and you can purchase a new premium licence if you wish.smile.png

    We will be here if you have any other questions, please don't hesitate to open other/new tickets, since our policy is to keep one subject per ticket.

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [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