Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #1453944
Export data from hidden columns
Closed

Comments

  •  3
    Ian Randell started the conversation
    February 1, 2018 at 3:31pm

    Dear Sirs,

    I have a database with about 20 fields in it. I want to display 10 in a table that can be filtered, but when I export to CSV or Excel, I want to export all 20 fields. I can see that I can add the fields to the table and then select them as hidden, but I cannot seem to export them as well as the viewed columns. Is there a way around this?

    Kind regards,

    Ian

  •  3
    Ian Randell replied
    February 1, 2018 at 4:57pm

    Dear Sirs,

    Having looked into my issue this afternoon, I think the Report Builder add on will solve my issue. I create a table with all 20 fields I want in my report and then I configure the report as I require it. I then hide the 10 fields that I don't want displayed on the front end. In my head that means that the front end displays the 10 fields I want, but the report can pull out all 20 fields. Please can you confirm that my thought process is correct here.

    Kind regards,

    Ian

  •  472
    Isidora replied
    February 2, 2018 at 10:36am

    Hi Ian,
    Thank you for your purchase.

    Yes you can use Report Builder add on if by fields you mean columns. My suggestion is you use our live presentation of all features of plugin and add ons on our sandbox so you can try it before buy.

    Kind Regards, 

    Isidora Markovic

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

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables