{"id":278,"date":"2011-03-19T14:45:10","date_gmt":"2011-03-19T18:45:10","guid":{"rendered":"http:\/\/cfdbplugin.com\/?page_id=278"},"modified":"2016-12-15T21:55:20","modified_gmt":"2016-12-16T02:55:20","slug":"cfdb-count","status":"publish","type":"page","link":"https:\/\/cfdbplugin.com\/?page_id=278","title":{"rendered":"[cfdb-count]"},"content":{"rendered":"

This documentation applies to version 2.6 and later<\/span><\/p>\n

Summary of Shortcode Options<\/strong><\/h1>\n\n\n\n\n\n\n\n\n\n\n\n
Option<\/strong><\/td>\nExample
\n<\/strong><\/td>\n		Description<\/strong><\/td>\n<\/tr>\n
form<\/strong><\/a><\/td>\n[cfdb-count\u00a0form=\"myform\"<\/strong>]<\/code><\/td>\nRequired. Designates the form to display. All rows and columns are displayed by default<\/td>\n<\/tr>\n
role<\/strong><\/a><\/td>\n[cfdb-datatable form=\"myform\" role=\"Author\"<\/strong>]<\/code><\/td>\nMake short code only display output for user’s with minimum-required role. Choices are<\/p>\n
    \n
  • Administrator<\/li>\n
  • Editor<\/li>\n
  • Author<\/li>\n
  • Contributor<\/li>\n
  • Subscriber<\/li>\n
  • Anyone<\/li>\n<\/ul>\n

    WARNING<\/strong>: this setting is overridden by plugin setting in WP Admin page Contact -> Database Options -> Can See Submission when using shortcodes
    \n(since 2.4.1)\n<\/td>\n<\/tr>\n

show<\/strong><\/a><\/td>\n[cfdb-count\u00a0form=\"myform\"\u00a0show=\"col1,col2\"<\/strong>]<\/code><\/td>\n**Not applicable to this shortcode<\/td>\n<\/tr>\n
hide<\/strong><\/a><\/td>\n[cfdb-count\u00a0form=\"myform\"\u00a0hide=\"col1,col2\"<\/strong>]<\/code><\/td>\n**Not applicable to this shortcode<\/td>\n<\/tr>\n
limit<\/strong><\/a><\/td>\n[cfdb-count\u00a0form=\"myform\"\u00a0limit=\"10\"<\/strong>]<\/code><\/td>\n** Applicable only if you would want to limit the count to a maximum number.<\/td>\n<\/tr>\n
orderby<\/strong><\/a><\/td>\n[cfdb-count\u00a0form=\"myform\"\u00a0orderby=\"last-name,first-name\"<\/strong>]<\/code><\/td>\n**Not applicable to this shortcode<\/td>\n<\/tr>\n
search<\/strong><\/a><\/td>\n[cfdb-count\u00a0form=\"myform\"\u00a0search=\"Simpson\"<\/strong>]<\/code><\/td>\nSelect rows to display that have any cell with the search text in it (case insensitive). Intended to mimic behavior of the “Search” field in the DataTable<\/td>\n<\/tr>\n
filter<\/strong><\/a><\/td>\n[cfdb-count\u00a0form=\"myform\"\u00a0filter=\"col1=Simpson\"<\/strong>]<\/code><\/td>\nSelect which rows to display based on filter expression. More powerful than “search”, it can filter on multiple columns with boolean and regular expressions. If both “search” and “filter” are specified, “search” is ignored.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


\n<\/span><\/p>\n

Example: Want to simply count of the number of form entries received? Maybe you want to show how many people have signed your on-line petition?<\/p>\n

[cfdb-count form=\"your-form\"]<\/code><\/p>\n

Example:\u00a0Want to show vote counts?<\/p>\n

Yes Votes: [cfdb-count\u00a0form=\"your-form\" filter=\"vote=yes\"]<\/code><\/p>\n

\n

No Votes: \u00a0[cfdb-count\u00a0form=\"your-form\" filter=\"vote=no\"]<\/code><\/code><\/p>\n

 <\/p>\n

<\/p>\n

The same thing can be accomplished with the [cfdb-value] shortcode, this shortcode is really just an abbreviation. <\/span><\/div>\n
So:<\/span><\/div>\n
\n

[cfdb-count\u00a0form=\"your-form\"]<\/code><\/p>\n

Is equivalent to: <\/span><\/div>\n<\/div>\n
\n

[cfdb-value\u00a0form=\"your-form\" function=\"count\"]<\/code><\/p>\n

But there is a subtle difference with cfdb-value. With that shortcode, if you use any other function rather than \"count\" (like \"sum\" or \"max\") then you need to specify the column or columns that will be applied. Otherwise it will try to compute across all columns. So if you used \"count\" and specified two columns, you get the number of entries submitted times two. Not a useful example, but if you were using \"mean\" it would be. <\/span><\/div>\n

\n<\/span><\/div>\n<\/div>\n

<\/code> <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Summary of Shortcode Options Option Example Description form Required. Designates the form to display. All rows and columns are displayed by default role Make short code only display output for user’s with minimum-required role. Choices are Administrator Editor Author Contributor Subscriber Anyone WARNING: this setting is overridden by plugin setting in WP Admin page Contact […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1577,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"page-without-sidebar.php","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-278","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/P1mptf-4u","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=278"}],"version-history":[{"count":15,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/278\/revisions"}],"predecessor-version":[{"id":1239,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/278\/revisions\/1239"}],"up":[{"embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/1577"}],"wp:attachment":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}