salemge

Thanks a lot for the updates.

mlapl1 and doit686868, I used both plugins and have the same problem here; tried to fix it without success. Have you found solutions?

Josh Pollock, you create a great form plugin and we are all very happy to use it. But CFDB provide us some opportunities to show entries in different ways by using shortcodes, not just a list for all the entries. For example:

1. add numbers in a column up;
2. a login user can only see his own entries; and
3. create “pivot table” type of entry listing.

Thank you.

Hi ka2,

The following statement created a table, but only the ‘id’ and ‘cpd_area’ columns show correct values; other columns show ‘NULL’ value.

CREATE TABLE wp_testing1
SELECT entry_id,
CASE
WHEN slug=’profession’ THEN value
ELSE NULL
END AS profession,

CASE
WHEN slug=’cpd_name’ THEN value
ELSE NULL
END AS cpd_name,

CASE
WHEN slug=’cpd_year’ THEN value
ELSE NULL
END AS cpd_year,

CASE
WHEN slug=’cpd_area’ THEN value
ELSE NULL
END AS cpd_area,

CASE
WHEN slug=’cpd_units’ THEN value
ELSE NULL
END AS cpd_units,

CASE
WHEN slug=’note’ THEN value
ELSE NULL
END AS note

FROM wp_cf_form_entry_values
GROUP BY entry_id;

Hi ka2,

I corrected the syntax and created a table. However only one column shows correct data, but other columns show “NULL”. Any idea what is happening?

Thanks You,