Okay
  Public Ticket #1453944
Export data from hidden columns
Closed

Comments

  •  3
    Ian Randell started the conversation

    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

    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

  •  471
    Isidora replied

    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: 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