{"id":98,"date":"2011-02-17T13:02:37","date_gmt":"2011-02-17T18:02:37","guid":{"rendered":"http:\/\/cfdbplugin.com\/?page_id=98"},"modified":"2016-12-15T21:55:15","modified_gmt":"2016-12-16T02:55:15","slug":"cfdb-value","status":"publish","type":"page","link":"https:\/\/cfdbplugin.com\/?page_id=98","title":{"rendered":"[cfdb-value]"},"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\n\n\n\n
Option<\/strong><\/td>\nExample
\n<\/strong><\/td>\n		Description<\/strong><\/td>\n<\/tr>\n
form<\/strong><\/a><\/td>\n[cfdb-value form=\"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-value form=\"myform\" show=\"col1,col2\"<\/strong>]<\/code><\/td>\nLimits columns to be shown to be those designated (comma-delimited list)<\/td>\n<\/tr>\n
hide<\/strong><\/a><\/td>\n[cfdb-value form=\"myform\" hide<\/span>=\"col1,col2\"<\/strong>]<\/code><\/td>\nDoes not show listed columns (comma-delimited list)<\/td>\n<\/tr>\n
limit<\/strong><\/a><\/td>\n[cfdb-value form=\"myform\"\u00a0limit=\"10\"<\/strong>]<\/code><\/td>\nOne number: limit=”10″ means show first 10 rows. Is the same as limit=”0,10″
\nTwo Numbers: limit=”100,10″ means show 10 rows starting at row #100)<\/td>\n<\/tr>\n
random<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\"\u00a0random=\"2\"<\/strong>]<\/code><\/td>\nDisplay 2 random rows from those that the short code finds. (Since 2.4)<\/td>\n<\/tr>\n
orderby<\/strong><\/a><\/td>\n[cfdb-value form=\"myform\"\u00a0orderby=\"last-name,first-name\"<\/strong>]<\/code><\/td>\nSort rows by designated columns. Use “column-name desc” to sort in descending (reverse) order<\/td>\n<\/tr>\n
search<\/strong><\/a><\/td>\n[cfdb-value form=\"myform\"\u00a0search<\/span>=\"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-value form=\"myform\" filter<\/span>=\"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
Options specific to this shortcode<\/em><\/td>\n<\/tr>\n
function<\/strong><\/a><\/td>\n[cfdb-value form=\"myform\"\u00a0function<\/span>=\"count\"<\/strong>]<\/code><\/td>\nCan be:\u00a0count<\/strong>, min<\/strong>, max<\/strong>, sum<\/strong>, mean<\/strong>, percent<\/strong>.<\/p>\n
    \n
  • count<\/strong><\/li>\n
  • min<\/strong><\/li>\n
  • max<\/strong><\/li>\n
  • sum<\/strong><\/li>\n
  • mean<\/strong><\/li>\n
  • percent<\/strong> (as of 2.0.1)<\/li>\n<\/ul>\n

    Use in conjunction with filter <\/strong>and show <\/strong>to select the rows and columns containing the data to input into the function.<\/p>\n

    WARNING: you generally want to pick ONLY ONE row in “show”. If you do not, all returned values will be used.<\/td>\n<\/tr>\n

delimiter<\/strong><\/a><\/td>\n[cfdb-value form=\"myform\"\u00a0delimiter<\/span>=\"|\"<\/strong>]<\/code><\/td>\nWhen multiple values are returned by the shortcode, by default they are printed with a ‘, ‘ delimiting them. Use this option to change that delimiter.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

 <\/p>\n

Don’t want a table or JSON? Just want to put a value in the page? Use the [cfdb-value]<\/code>shortcode<\/p>\n

Example:<\/p>\n

[cfdb-value form=\"your-form\" show=\"field1\" filter=\"Submitted Login=$user_login\"] <\/code><\/p>\n

would display the field1 <\/strong>form value for the currently viewing user (who would have needed to be logged in when he submitted…see documentation on $user_login variable substitution<\/a>).<\/p>\n

The intention is to specify one column\/field inshow<\/code>and specify afilter<\/code>that would select on submission. (see how this works for[cfdb-table]<\/code>) But if you specify more columns or have more submissions (rows) resulting in the filter, then this shortcode will print out a comma-delimited list of values. You can also usehide<\/code>.<\/p>\n

<\/a> Functions<\/strong><\/p>\n

 <\/p>\n

count<\/strong><\/p>\n

Count rows:\u00a0\u00a0[cfdb-value function=\"count\" form=\"myform\"]<\/code><\/p>\n

Count entries in column “col1”: \u00a0[cfdb-value function=\"count\" form=\"myform\" show=\"col1\"]<\/code><\/p>\n

min<\/strong><\/p>\n

Minimum entry in column “col1”:\u00a0[cfdb-value function=\"min\" form=\"myform\" show=\"col1\"]<\/code><\/p>\n

 <\/p>\n

max<\/strong><\/p>\n

Maximum entry in column “col1”:\u00a0[cfdb-value function=\"max\" form=\"myform\" show=\"col1\"]<\/code><\/p>\n

sum<\/strong><\/div>\n

 <\/p>\n

Sum of entries in column “col1”: \u00a0[cfdb-value function=\"sum\" form=\"myform\" show=\"col1\"]<\/code><\/p>\n

mean<\/strong><\/p>\n

Mean\u00a0of entries in column “col1”: \u00a0[cfdb-value function=\"mean\" form=\"myform\" show=\"col1\"]<\/code><\/p>\n

 <\/p>\n

<\/a> delimiter<\/strong><\/p>\n

Available as of version 1.8.4. Specify a delimiter to be put between multiple values. Note: if you are using a function then it will always return one value, so there will never be a delimiter. So ‘function’ and ‘delimiter’ are mutually exclusive.<\/p>\n

Example:\u00a0[cfdb-value form=\"myform\" show=\"col1\" delimiter=\"|\"]<\/code><\/p>\n

In this case, if there is more than one entry in the DB for this form, all the “col1” values will printed delimited with a “|”, e.g. “submission1-col1|submission2-col1|submission3-col1”<\/p>\n

NOTE: if you want more complex formatting of the output, use the [cfdb-html<\/a>] <\/code> shortcode instead.<\/p>\n

 <\/p>\n

percent<\/strong><\/p>\n

Returns a percentage value of the \u00a0(number of\u00a0\u00a0form entries matching your show and filter criteria) \/ (total number of form submissions for the form).<\/p>\n

Limitation: this is always a percent of the total number of entries in the database. However, you can create a short code to compute a percentage on a subset of a form’s submissions<\/a>.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\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":3,"comment_status":"closed","ping_status":"closed","template":"page-without-sidebar.php","meta":{"footnotes":""},"class_list":["post-98","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/P1mptf-1A","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/98","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=98"}],"version-history":[{"count":28,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/98\/revisions"}],"predecessor-version":[{"id":1066,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/98\/revisions\/1066"}],"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=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}