Title: jammerpro's Replies | WordPress.org --- # jammerpro [ ](https://wordpress.org/support/users/jammerpro/) * [Profile](https://wordpress.org/support/users/jammerpro/) * [Topics Started](https://wordpress.org/support/users/jammerpro/topics/) * [Replies Created](https://wordpress.org/support/users/jammerpro/replies/) * [Reviews Written](https://wordpress.org/support/users/jammerpro/reviews/) * [Topics Replied To](https://wordpress.org/support/users/jammerpro/replied-to/) * [Engagements](https://wordpress.org/support/users/jammerpro/engagements/) * [Favorites](https://wordpress.org/support/users/jammerpro/favorites/) Search replies: ## Forum Replies Created Viewing 6 replies - 1 through 6 (of 6 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Sum of Rows in Queries and Templates](https://wordpress.org/support/topic/sum-of-rows-in-queries-and-templates/) * Thread Starter [jammerpro](https://wordpress.org/support/users/jammerpro/) * (@jammerpro) * [2 years, 7 months ago](https://wordpress.org/support/topic/sum-of-rows-in-queries-and-templates/#post-17098318) * [Kim L](https://wordpress.org/support/users/kimmyx/) [@kimmyx](https://wordpress.org/support/users/kimmyx/)) and [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)( @peterschulznl), * We have gone beyond the point above, and the shortcode for the Advanced Options in the Table code under the Test in Table Builder, and the shortcode the Extra Code we inserted on the Front End Page with Code Manager are co-existing, but the reports DO NOT WORK in the same manner. * The Page gets a page column total now, but we are having trouble with the pagination and Select Box issue, which you resolved. We may now be able to get something meaningful through search because we will get to all entries from the database. * We will work a bit more on this and report back. * It would be a great feature to have an easy way to sum columns across all entries in the database, and get a Grand Total for all the Totals of all columns and entries. * We are fixated on building a professional, running balance ledger and invoice system geared to services with time entries we enter in the form. * I’ll be back. - This reply was modified 2 years, 7 months ago by [jammerpro](https://wordpress.org/support/users/jammerpro/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Increase Selection Values in Show Entries Select Box under Table Builder -Test](https://wordpress.org/support/topic/increase-selection-values-in-show-entries-select-box-under-table-builder-test/) * Thread Starter [jammerpro](https://wordpress.org/support/users/jammerpro/) * (@jammerpro) * [2 years, 7 months ago](https://wordpress.org/support/topic/increase-selection-values-in-show-entries-select-box-under-table-builder-test/#post-17098129) * Thanks [Kim L](https://wordpress.org/support/users/kimmyx/) (@kimmyx). Works great. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Sum of Rows in Queries and Templates](https://wordpress.org/support/topic/sum-of-rows-in-queries-and-templates/) * Thread Starter [jammerpro](https://wordpress.org/support/users/jammerpro/) * (@jammerpro) * [2 years, 7 months ago](https://wordpress.org/support/topic/sum-of-rows-in-queries-and-templates/#post-17095213) * Hi [@peterschulznl](https://wordpress.org/support/users/peterschulznl/) * Thanks so much for your help. * Kindly take a quick look at my very first post in this thread as follows: * _____________________________________________________________________ How do I get a GRAND TOTAL of the “Totals” at the bottom? Here’s the code: * ```wp-block-code select billing.*, client.client, client.id, (time_spent*wage+charge-payment)from billing,client WHERE billing.client=client.id && client.id=44 ORDER BY client.client ASC ``` * Works perfectly, except, there is no way I know of using just a MySQL select to get the GRAND TOTAL I seek and place it at the end of the result column. ____________________________________________________________________________ * [Kim L](https://wordpress.org/support/users/kimmyx/) [@kimmyx](https://wordpress.org/support/users/kimmyx/) was kind enough to direct us to [https://datatables.net/examples/advanced_init/footer_callback.html](https://datatables.net/examples/advanced_init/footer_callback.html) to get footer callback code to place in the advanced editor. Also loaded your Code Manager to load some JQUERY. The Javascript Kim supplied was a good example, but was not just a cut and paste. We were able to use the Code Manager and the Advanced Section and created shortcodes from the Table Builder to create a Page to display the result which worked! **HOWEVER…** while the shortcodes work perfectly on the Page, the View and Test Buttons under the table in Table Builder DO NOT. They crash and keep processing. Those little blue balls of death keep spinning. If we remove the shortcodes, the View and Test under the table in the Table Builder work perfectly; HOWEVER, then the shortcodes don’t work on the Page. Damned if you do, damned if you don’t. LOL. * THE IMPORPORTANT QUESTION WE NEED ANSWERED IS… * In the JQuery Code we used in the Code Manager, or the JSON we used in the Advanced Section,, how do we disable your Table Builder from accessing the footer callback in the Advanced Section together with the JQUERY code in your Code Manager, while allowing it to generate a shortcode that works in the Page? * That would solve the problem. * Hopefully, you understand what I’m asking. * Best wishes on a great product and fantastic community! - This reply was modified 2 years, 7 months ago by [jammerpro](https://wordpress.org/support/users/jammerpro/). - This reply was modified 2 years, 7 months ago by [jammerpro](https://wordpress.org/support/users/jammerpro/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Sum of Rows in Queries and Templates](https://wordpress.org/support/topic/sum-of-rows-in-queries-and-templates/) * Thread Starter [jammerpro](https://wordpress.org/support/users/jammerpro/) * (@jammerpro) * [2 years, 7 months ago](https://wordpress.org/support/topic/sum-of-rows-in-queries-and-templates/#post-17090473) * Hi [Kim L ](https://wordpress.org/support/users/kimmyx/)(@kimmyx), * Just tried the script you suggested to total a known row with a callback, but kept getting a parse error. * My Database is: CloudLawApp Table: billingColumns are: date_b,client,id,employee, job_type,job_type2,time_spent,wage,charge,payment,description * Not sure how to fix the syntax in the script you suggested so that I can at least total a known column in the footer. If you could fill in the example using my column “payment” in database “CloudLawApp” in table “billing” it would help me to learn how to convert those javascripts into your Advanced Section. * Also, I am still not sure how to add a virtual column to my table to show the result I need at the end of the row (time_spent*wage-charge+payment). * Any guidance would be greatly appreciated. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Sum of Rows in Queries and Templates](https://wordpress.org/support/topic/sum-of-rows-in-queries-and-templates/) * Thread Starter [jammerpro](https://wordpress.org/support/users/jammerpro/) * (@jammerpro) * [2 years, 7 months ago](https://wordpress.org/support/topic/sum-of-rows-in-queries-and-templates/#post-17089776) * Hi [Kim L ](https://wordpress.org/support/users/kimmyx/)(@kimmyx), * Thanks for your response. The footer callback is a possibility, but first I need to know how to display the following in a virtual row so I can get the timeslip balance to the data table: * (time_spent*wage+charge-payment) * Look at my query above, which works in queries to give the result after each row… It’s that row I want to use in the callback. * How do I do that in data tables? Is there such a thing as a virtual row? * Thanks again! - This reply was modified 2 years, 7 months ago by [jammerpro](https://wordpress.org/support/users/jammerpro/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Display column sum in post (newbie alert)](https://wordpress.org/support/topic/display-column-sum-in-post-newbie-alert/) * [jammerpro](https://wordpress.org/support/users/jammerpro/) * (@jammerpro) * [2 years, 7 months ago](https://wordpress.org/support/topic/display-column-sum-in-post-newbie-alert/#post-17081835) * Here’s a MySQL query that will sum “row2” and order it by “row1″… * Works! * SELECT _row1_, SUM(_row2_) “Total from _table_ GROUP BY _row1_ ORDER BY _row1_ ASC * BUT MY QUESTION IS HOW DO YOU INSERT THIS IN A TEMPLATE AT THE FOOT OF THE LIST? - This reply was modified 2 years, 7 months ago by [jammerpro](https://wordpress.org/support/users/jammerpro/). - This reply was modified 2 years, 7 months ago by [jammerpro](https://wordpress.org/support/users/jammerpro/). - This reply was modified 2 years, 7 months ago by [jammerpro](https://wordpress.org/support/users/jammerpro/). - This reply was modified 2 years, 7 months ago by [jammerpro](https://wordpress.org/support/users/jammerpro/). Viewing 6 replies - 1 through 6 (of 6 total)