{"id":284,"date":"2011-03-19T15:12:16","date_gmt":"2011-03-19T19:12:16","guid":{"rendered":"http:\/\/cfdbplugin.com\/?page_id=284"},"modified":"2016-12-15T21:55:24","modified_gmt":"2016-12-16T02:55:24","slug":"cfdb-html","status":"publish","type":"page","link":"https:\/\/cfdbplugin.com\/?page_id=284","title":{"rendered":"[cfdb-html]"},"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\n
Option<\/strong><\/td>\nExample <\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
form<\/strong><\/a><\/td>\n[cfdb-html\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)<\/td>\n<\/tr>\n

show<\/strong><\/a><\/td>\n[cfdb-html\u00a0form=\"myform\"\u00a0show=\"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-html\u00a0form=\"myform\"\u00a0hide=\"col1,col2\"<\/strong>]<\/code><\/td>\nDoes not show listed columns (comma-delimited list)<\/td>\n<\/tr>\n
limit<\/strong><\/a><\/td>\n[cfdb-html\u00a0form=\"myform\"\u00a0limit=\"10\"<\/strong>]<\/code><\/td>\nOne number: limit=”10″ means show first 10 rows. Is the same as limit=”0,10″ Two 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-html\u00a0form=\"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-html\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-html\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
Options specific to this shortcode<\/em><\/td>\n<\/tr>\n
filelinks<\/strong><\/a><\/td>\n[cfdb-html\u00a0form=\"myform\"\u00a0filelinks=\"img\"<\/strong>]<\/code><\/td>\nSelect how uploaded file fields should be output.
\nOptions are<\/p>\n
    \n
  • url <\/strong>– output URL to download file<\/li>\n
  • name <\/strong>– outputs simple file name<\/li>\n
  • link <\/strong>– outputs and HTML link (“a” tag) linking to download the file<\/li>\n
  • img <\/strong>or image <\/strong>– assumes the file is an image file and embeds the image in page (“img” tag)<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
<\/a>stripbr<\/strong><\/a><\/td>\n[cfdb-html\u00a0form=\"myform\"\u00a0stripbr=\"true\"<\/strong>]<\/code><\/td>\n*** Available as of 2.1 ***”Strip BR tags”. This is an alternative to wpautop which often does not work. If this option is set to “true” then all “<br \/><\/strong>” tags will be removed from the output. The intention is to strip out BR tags injected by the WordPress\u00a0\u00a0wpautop<\/a>\u00a0function.The unintended consequence may be that it strips out BR tags that you put in the HTML template of this tag. The trick to make that work is to put in BR tags without a space, that is “<br\/><\/strong>” or use capital letters. This option only removes BR tags that exactly match\u00a0\u00a0“<br \/>”You might also consider using a plugin to turn off wpautop for a specific post<\/a>. In that plugin, you set a customer field on the post to turn off wpautop<\/td>\n<\/tr>\n
<\/a>wpautop<\/strong><\/a><\/td>\n[cfdb-html\u00a0form=\"myform\"\u00a0wpautop=\"true\"<\/strong>]<\/code><\/td>\n*** THIS MAY NOT WORK IN RECENT VERSIONS OF WORDPRESS ***<\/strong>*** DEPRECATED AS OF VERSION 2.1. USE “stripbr” OPTION INSTEAD ***<\/strong>
\nTurn on or off wpautop for the short code. Valid values are “true” or “false”. If not specified, “false” is the default. WP likes to automatically inject HTML P and BR tags into content text to try to reflect where users have typed in line breaks. This is called wpautop<\/a>. This affects the content\/template text this shortcode (the text between the open and close tags). If you are not putting HTML tags in that content, you might wish to set wpautop=”true” to have WP preserve your line breaks. But if you are putting in your own HTML, then you will likely want wpautop=”false” to prevent WP from injection extraneous BR and P tags into your markup.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Want to get your data into an HTML format that you want instead of in a table and not in Javascript\/JSON? This is the shortcode for you.<\/p>\n

<\/a>Template<\/strong>
\nBest explained with an example. Imagine an example similar to\u00a0showing WordPress blog entries. If you imagine that a form submission is a blog entry, you could use this shortcode to show the most recent 10 blog entries.<\/p>\n

[cfdb-html form=\"blogs\" show=\"name,title,blogtext<\/strong>\" limit=\"10\" orderby=\"Submitted desc\"]<\/code><\/p>\n

<div class=\"your-headline-style\">${name}<\/strong>: ${title}<\/strong><\/div><\/code><\/p>\n

<div class=\"your-content-style\">${blogtext}<\/strong><\/div><\/code><\/p>\n

[\/cfdb-html] <\/span><\/p>\n

Unlike other shortcodes, we use the begin-tag [cfdb-html]Template<\/span> [\/cfdb-html] end-tag format. The template content inside the tag is repeated for each row returned by the shortcode.<\/p>\n

You use the ${column-name}<\/strong> syntax to show where values for each row should be inserted. Be sure that all such substitution names are in your “show” list, or simply omit “show”.<\/p>\n

<\/a> Use filelinks<\/code> to indicate how form files that are uploaded files should be treated.<\/p>\n

Options are:<\/p>\n