Unofficial CForms II table display

Replaces a shortcode such as [cformstable form='nameofyourform'] with a table of data or a count of information collected via the excellent CForms II. Examples would be:

• [cformstable form='nameofyourform'] to display how many entries have been collected by your form
• [cformstable form='nameofyourform' display='table' vars='Name,Date,Comment'] to display a table of entries collected by your form

Possible variables for your shortcode include: General Variables

• display = 'number' or 'table' - (the default is 'number')
• form = 'the name of your form' - if you don't know the names of possible forms, just use [cformstable] to get a list of options
• from = DATETIME string (format: Y-m-d H:i:s). Date & time defining the start of a target period, e.g. 2008-09-17 15:00:00 (optional)
• to =DATETIME string (format:Y-m-d H:i:s). Date & time defining the end of a target period, e.g.2014-09-17 15:00:00` (optional)
• limit = 'the maximum lines to show in the table or count' (optional)

Table Variables Either

• vars = list of variable names to use as column headers separated by commas e.g. 'Name,Date,Comment'. To change the way the name is displayed, add your revised text after |, e.g. vars='Name|Your Name,Date,Comment'

Or

• cols = list of variable numbers to use as column headers separated by commas e.g. '1,2,3'. You can get variable numbers by posting [cformstable display='table' form='Name of your form']. As with the vars setting, to change the way the name is displayed, add your revised text after |, e.g. cols='1|Your Name,2,3'.

Optional Variables

• limit = 'the maximum lines to show in the table' (optional)
• sortdir = 'asc' or 'desc' (optional)
• sort = 'form', 'id', 'date', 'ip' or 'email' or any other form input field, e.g. 'Your Name' (optional)

Count Variables

• deduped = TRUE or FALSE - remove duplicate IP/email addresses from count (optional)
• adjust = 'n' where n is a numerical value (+10, -20 etc.) to adjust the count displayed up or down (optional)

1.1.3

• Solves a potential problem where variable numbers would depend on sort values

1.1.2

• Resolves an empty table cell problem.

1.1.1

• Resolves a 'hidden column' problem with variables added to the form after the first question was answered.

1.1.0

• Adds variables that weren't in the original version of the form to the cols list

1.0.4

• Fixing italicisation problem

1.0.3

• Further fix to sort setting

1.0.2

• Fixed sort setting

1.0.1

• Fixing sort problem with cols variable.
• Fixing slashes problem with column names

1.0

• Addition of cols variable to shortcode to allow people to select variables for display by number e.g. cols='1,2,3,4'

0.25 Fixes bug with permissions. 0.24 Add two new variables to cformstable: adjust and deduped 0.23 Fixed bug where selected table is empty. 0.221 Fully fixed bug where count is zero 0.22 Fixed bug where count is zero 0.21 Partial fix of bug where count is zero 0.2 First published version