Sorry I’m not sure what you mean. Do you mean a list item in a form based on a column from a spreadsheet?
Sorry, been a while since I’ve dealt with databases. The [formdata] shortcode lists all the data from whatever form slug you tell it to, I want to list the data from a single column in that slug, rather than all of it.
It turns out I forgot to put this in the FAQ. You can restrict the table to only certain fields using their nicknames separated by commas. The shortcode would look like:
[formdata form-1 table show="foo,bar,blah"]
Ah, thank you. Is there any way to change the template of the “table” output or any way to show a column without this option?
I know in the FAQ the shortcode [formdata (slug) show="foo,bar,etc"]
is supposed to work like this, but when I use it like that I get all the data from all the columns and not the limited data I’ve asked for.
There isn’t a template system for outputting the data, unfortunately. If it is showing columns that you haven’t named then this is a bug. Unfortunately I tested it on my end and it is working. What form items do you have?
I am having the same problem I use the formdata code to post only certain fields (ie: “show=”nickname,nickname”) and it’s not working. Shows all data.
Mike, the problem was you need to include ‘table’ in the shortcode:
[formdata (slug) table show="..."]
@hoffcamp How do you just display the field for the post without showing every entry from other posts for that field. I don’t get the point of that. I just want to call a specific field in a specific spot in the post template. I couldn’t find any documentation for that.
I’m not sure what you mean, if you want to show just a particular submission, that is not something you can do. You can only show a list. I want to include some options for querying the submission data via shortcodes in future versions, though.
If you want to hide empty fields, I added an option in 1.6.30, under the ‘Advanced’ tab in the form editor, under ‘Submission Fields’.