Title: ericc44's Replies | WordPress.org --- # ericc44 [ ](https://wordpress.org/support/users/ericc44/) * [Profile](https://wordpress.org/support/users/ericc44/) * [Topics Started](https://wordpress.org/support/users/ericc44/topics/) * [Replies Created](https://wordpress.org/support/users/ericc44/replies/) * [Reviews Written](https://wordpress.org/support/users/ericc44/reviews/) * [Topics Replied To](https://wordpress.org/support/users/ericc44/replied-to/) * [Engagements](https://wordpress.org/support/users/ericc44/engagements/) * [Favorites](https://wordpress.org/support/users/ericc44/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 21 total) 1 [2](https://wordpress.org/support/users/ericc44/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/ericc44/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Create Charts from TablePress](https://wordpress.org/support/topic/create-charts-from-tablepress/) * [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [8 years, 9 months ago](https://wordpress.org/support/topic/create-charts-from-tablepress/#post-9639796) * Hi Veloctyceo, you can using Chartist.js, this TablePress Extension creates a responsive chart based on the data in a TablePress table. [link](https://wordpress.org/plugins/charts-for-tablepress-chartist/) * Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Embedding table into an email](https://wordpress.org/support/topic/embedding-table-into-an-email/) * [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [8 years, 9 months ago](https://wordpress.org/support/topic/embedding-table-into-an-email/#post-9637667) * Hi Tobias, is it possible to test this addon to send an email ? * Thanks WPChina for your addon, best regards. * Best wishes, Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Embedding table into an email](https://wordpress.org/support/topic/embedding-table-into-an-email/) * [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [8 years, 10 months ago](https://wordpress.org/support/topic/embedding-table-into-an-email/#post-9568779) * Hi WPChina and Tobias. Thank you for your support. * Sorry, but actualy when we using EXCEL Button : we saving table to an Excel (. xlsx) file to local user machine. * I just want a new button to save this Excel (.xlsx) file to a fix email adress or web server or other… We want to offer the user the possibility of recording his result to a centralized place to make statistics of the choices of the different users. * Is it possible ? Thanks Best regards * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Embedding table into an email](https://wordpress.org/support/topic/embedding-table-into-an-email/) * [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [8 years, 10 months ago](https://wordpress.org/support/topic/embedding-table-into-an-email/#post-9566739) * Hi WPChina and Tobias, i want to send Embedding Excel table into an email. Have you a solution ? I want to use a button and sending table at excel format to a fix email adress. [ScreenPicture](https://prnt.sc/gup98w) * Thanks Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] AUTOSUM](https://wordpress.org/support/topic/autosum/) * [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [8 years, 11 months ago](https://wordpress.org/support/topic/autosum/#post-9474851) * Hi, Thanks Tobias it is true. * Note : first column number is 0 This code is correct and should sum all column 1 (column number 2 of your table) and add text ‘Totals :’ in your column 2 (column number 3 of your table). Can you check you have only number in column 1 ? * Can you put a table link to check, please. * Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] AUTOSUM](https://wordpress.org/support/topic/autosum/) * [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [8 years, 11 months ago](https://wordpress.org/support/topic/autosum/#post-9471723) * Hi, if you want to use SUM just the visible rows which have been filtered, it necessary to add a Table Footer You should add a new row to the end of the table and click the “Table Footer” row as well. and you can see [Sum of column](https://wordpress.org/support/topic/how-to-compute-a-sum-for-a-column-of-figures/#post-9427209) * Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] How to compute a sum for a column of figures?](https://wordpress.org/support/topic/how-to-compute-a-sum-for-a-column-of-figures/) * [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [8 years, 11 months ago](https://wordpress.org/support/topic/how-to-compute-a-sum-for-a-column-of-figures/#post-9427079) * Hi, [to have Round a number to the nearest integer](https://www.w3schools.com/jsref/jsref_round.asp): just replace this code `$( api.column(1 ).footer() ).html( total );` to `$( api. column(1 ).footer() ).html( Math.round(total ));` * [To have only two decimals](https://www.w3schools.com/jsref/jsref_tofixed.asp) just replace this code `$( api.column(1 ).footer() ).html( total );` to `$( api. column(1 ).footer() ).html( total.toFixed(2));` * P.S.: In case you haven’t to TOBIAS, please rate TablePress here in the plugin directory. Thanks! * Have a good day Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] How to compute a sum for a column of figures?](https://wordpress.org/support/topic/how-to-compute-a-sum-for-a-column-of-figures/) * [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [8 years, 12 months ago](https://wordpress.org/support/topic/how-to-compute-a-sum-for-a-column-of-figures/#post-9423187) * Hi, 1- In addition, your table does not have a table footer. You should add a new row to the end of the table and click the “Table Footer” row as well. * 2- Paste this code to “Custom Commands” textfield without CR LF `"footerCallback": function( row, data, start, end, display ) { var api = this.api(), data; var intVal = function ( i ) { return typeof i === 'string' ? i.replace(/[\$,]/g, '')* 1 : typeof i === 'number' ? i : 0; }; total = api .column( 1, { page: 'current'}). data() .reduce( function (a, b) { return intVal(a) + intVal(b); }, 0 ); $( api. column(1 ).footer() ).html( total ); $( api.column( 0 ).footer() ).html('Total:');}` Note : first column number is 0 * Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress Extension: Chartist] Using data footer line for Piepercent](https://wordpress.org/support/topic/using-data-footer-line-for-piepercent/) * Thread Starter [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [9 years ago](https://wordpress.org/support/topic/using-data-footer-line-for-piepercent/#post-9403937) * Hi Silsha, thank you for a solution. Just more information : – Yes I want the first row of table as label ‘table_head’, that now is OK – and the last row ( Footer) as value for PiePercent chart ‘table_footer’ but i add the footer data to Tablepress with `"dom": "WBlfirtip", "footerCallback": function( row, data, start, end, display ) { var api = this.api(), data; var intVal = function ( i){ return typeof i === 'string' ? i.replace(/[\$,]/g, '')*1 : typeof i === 'number'? i : 0; }; totalModele = api .column( 3, { page: 'current'} ) .data() .reduce( function (a, b) { return intVal(a) + intVal(b); }, 0 ); totalListe = api.column( 4, { page: 'current'} ).data().reduce( function (a, b) { return intVal(a) + intVal( b); }, 0 ); totalValeur2 = api .column( 5, { page: 'current'} ) .data() .reduce( function (a, b) { return intVal(a) + intVal(b); }, 0 ); $( api.column(3 ).footer()). html( totalModele ); $( api.column(4 ).footer() ).html( totalListe ); $( api. column(5 ).footer() ).html( totalValeur2 ); $( api.column( 2 ).footer() ).html(' Total'); }` * Another suggest is it possible to have information over the mousse pointer like GoogleChart Displays tooltips when hovering over slices. [GoogleChart](https://developers.google.com/chart/interactive/docs/gallery/piechart) [Displays tooltips when hovering over slices. ](https://prnt.sc/g7kbip) * Or is it possible to use data TablePress with GoogleChatrs function ? * Thanks Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Display total sum data of column ?](https://wordpress.org/support/topic/display-total-sum-data-of-column/) * Thread Starter [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [9 years ago](https://wordpress.org/support/topic/display-total-sum-data-of-column/#post-9340167) * Hi Tobias, good news, to have dynamic function for current page just add `{ page: 'current'` change `total = api.column( 4 ).data()` to `total = api.column( 4, { page: 'current'} ).data()` * Is it possible to have code to paste it into the “Custom Commands” textfield to load an external JavaScript file code ? Because it more easy to read and to add comment that single line. * Thanks for all Best regards * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Display total sum data of column ?](https://wordpress.org/support/topic/display-total-sum-data-of-column/) * Thread Starter [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [9 years ago](https://wordpress.org/support/topic/display-total-sum-data-of-column/#post-9337761) * OK for comma, sorry i have tested with ; and {} How i can modified code to have dynamic function like [Datatable](https://datatables.net/examples/advanced_init/footer_callback.html) * Thank you very much Regards * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress Extension: Chartist] Disable diplay for 0% values](https://wordpress.org/support/topic/disable-diplay-for-0-values/) * Thread Starter [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [9 years ago](https://wordpress.org/support/topic/disable-diplay-for-0-values/#post-9337666) * Thank you very much Silsha. It is ok for color and can you tell me when you have a solution for option to hide labels for values below x. * Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Display total sum data of column ?](https://wordpress.org/support/topic/display-total-sum-data-of-column/) * Thread Starter [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [9 years ago](https://wordpress.org/support/topic/display-total-sum-data-of-column/#post-9337631) * Great work TOBIAS, thank you very much. * 1) I’m surprised, sum isn’t dynamic, if you select a value filter the sum don’t change. Is it possible to have dynamic function ? [https://prnt.sc/fy6jvu](https://prnt.sc/fy6jvu) [Test3](http://chotard.clement.free.fr/?page_id=486) * 2) I use this code `"dom": "WBlfirtip"` to “Custom Commands” textfield to display Button and filter like [TEST2](http://chotard.clement.free.fr/?page_id=493) How i can add this code with “footerCallback”: function * 3) Is it possible to have sum for all column, what code modification ? * Thanks Best regards Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Display total sum data of column ?](https://wordpress.org/support/topic/display-total-sum-data-of-column/) * Thread Starter [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [9 years ago](https://wordpress.org/support/topic/display-total-sum-data-of-column/#post-9336192) * Hi Tobias, thank you for your help. I have created two pages TEST2 and Test3 with same informations just TABLE are different : Test2 have [table id=2] and TEST3 have [table id=3] * [TEST2](http://chotard.clement.free.fr/?page_id=493) [Test3](http://chotard.clement.free.fr/?page_id=486) * I just copy this code to “Custom Commands” textfield without CR LF to [table id=3] `"footerCallback": function ( row, data, start, end, display ) { var api = this.api(), data; total = api .column( 5 ) .data() .reduce( function (a, b){ return intVal(a) + intVal(b); }, 0 ); $( api.column( 5 ).footer() ).html( total +' total)' ); }` * When i use this code filter menu don’t work. I don’t have text value “Total” + value display on footer on column 5. * Thanks Eric * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] Display total sum data of column ?](https://wordpress.org/support/topic/display-total-sum-data-of-column/) * Thread Starter [ericc44](https://wordpress.org/support/users/ericc44/) * (@ericc44) * [9 years ago](https://wordpress.org/support/topic/display-total-sum-data-of-column/#post-9334113) * HI, i have update the code source * ``` "footerCallback": function ( row, data, start, end, display ) { var api = this.api(), data; /* Total over all pages */ total = api .column( 5 ) .data() .reduce( function (a, b) { return intVal(a) + intVal(b); }, 0 ); /* Update footer */ $( api.column( 5 ).footer() ).html( total +' total)' ); } ); ``` * I copy this code to “Custom Commands” textfield without CR LF `"footerCallback": function ( row, data, start, end, display ) { var api = this.api(), data; total = api .column( 5 ) .data() .reduce( function (a, b) { return intVal(a) + intVal( b); }, 0 ); $( api.column( 5 ).footer() ).html( total +' total)' ); } );` * But i don’t have text value “Total” + value display on footer. * Where is the problem ? * Please Thanks Eric Viewing 15 replies - 1 through 15 (of 21 total) 1 [2](https://wordpress.org/support/users/ericc44/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/ericc44/replies/page/2/?output_format=md)