Hide export button for large tables

vitorleo80

I'm trying to find a solution to hide an export CSV button if the table has more than 5000 rows. Someone could help? Thanks

rf1234

I would use table.rows().count()
https://datatables.net/reference/api/count()
https://datatables.net/reference/api/rows()

and use this event to do the counting:
https://datatables.net/reference/event/init

in the buttons part of your table definition you will have something like this:

buttons: [
.....
    {  extend: "csv", className: "csvButton"  },
.....
]

And you'll have something like this, too.

yourTable
   .on('init', function () {
        if ( yourTable.rows().count() > 5000 ) {
           yourTable.buttons('.csvButton').nodes().addClass('hidden');
        } else {
            yourTable.buttons('.csvButton').nodes().removeClass('hidden');
    })

colin

Hi @vitorleo80 ,

The best place would be to call button().remove() in initComplete - you can get a row count with rows().count(),

Cheers,

Colin

vitorleo80

Thanks for your help.

rf1234

You are welcome! As you can see, many roads lead to Rome! Data tables is so flexible that I sometimes think it is too flexible ...