Title: Total sum shortcode
Last modified: August 31, 2016

---

# Total sum shortcode

 *  [riasage](https://wordpress.org/support/users/riasage/)
 * (@riasage)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/)
 * Is it possible to create a shortcode that can sum the total of a number row/column?
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 9 replies - 1 through 9 (of 9 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7169753)
 * Within a row you can add fields:
    trans=”newfield=sum(field1,field2,field3)”
 * Also see:
    SumField SummationRow [http://cfdbplugin.com/?page_id=1167](http://cfdbplugin.com/?page_id=1167)
 *  Thread Starter [riasage](https://wordpress.org/support/users/riasage/)
 * (@riasage)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7169878)
 * Thank you Michael for your help. So I use this short code and ended with a table
   showing. Is the a possibility to show only the SUM value only?
 * [cfdb-table form=”Meaningful Conversation” trans=”SummationRow(number)”]
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7169883)
 * Try:
 * [cfdb-table form=”Meaningful Conversation” trans=”SummationRow(number)” limit
   =”1″ orderby=”submit_time ASC”]
 *  Thread Starter [riasage](https://wordpress.org/support/users/riasage/)
 * (@riasage)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7169989)
 * Thank you very much. It worked. But the font size is very small. is there away
   to increase the font size of the numerical output?
 * Here is the site: [http://data.grlpro.com](http://data.grlpro.com)
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7169996)
 * You can inject CSS like this:
 * [cfdb-table form=”Meaningful Conversation” trans=”SummationRow(number)” limit
   =”1″ orderby=”submit_time ASC” **id=”mytable” style=”#mytable { font-size: large;}”**]
 *  Thread Starter [riasage](https://wordpress.org/support/users/riasage/)
 * (@riasage)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7169998)
 * Thank you it worked. But the plugin’s formatting was generally affected by WP
   page visibility setting. I turned on password protection and this is what happen.
   See screenshots below;
 * With password: [https://www.dropbox.com/s/olk6yxzy79nzb4j/With%20PW.png?dl=0](https://www.dropbox.com/s/olk6yxzy79nzb4j/With%20PW.png?dl=0)
   
   Without password: [https://www.dropbox.com/s/hq52etcflhzwep7/without%20PW.png?dl=0](https://www.dropbox.com/s/hq52etcflhzwep7/without%20PW.png?dl=0)
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7170001)
 * The plugin can create a table and it gives you a place where you can put CSS 
   if you want. But getting the styles the way you want it on your page with your
   theme is up to you.
 *  Thread Starter [riasage](https://wordpress.org/support/users/riasage/)
 * (@riasage)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7170002)
 * Thank you… By the way I just want to mention now that, your support is way way
   better than some of the paid support out there. Thank you very much for that.
   I will definitely donate to support your plugin development.
 * Anyway back to the issue. So I want is the way it is when I do not activate the
   password protection. But I want to page to be password protected. By when I turn
   on the password protection, it creates the visible lines around the numbers. 
   So if I want to remove those lines, where do I make the changes? The theme or
   the plugin?
 * Thank yo again for your help in this matter
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7170004)
 * Thanks.
 * The plugins outputs the same table HTML regardless of whether the page is password
   protected. You can look at the page HTML to verify this. So it must be the theme
   or something else in the mix.
 * Maybe you can just set no border explicitly:
 * [cfdb-table form=”Meaningful Conversation” trans=”SummationRow(number)” limit
   =”1″ orderby=”submit_time ASC” id=”mytable” **style=”#mytable { font-size: large;
   border-style: none; }”**]

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Total sum shortcode’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 9 replies
 * 2 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [10 years ago](https://wordpress.org/support/topic/total-sum-shortcode/#post-7170004)
 * Status: not resolved