Gavin, I suggest you update your Participants Database, the latest version has a much better interface for assigning columns in the list, it’s called “Manage List Columns” in the plugin’s admin menu.
Thank you so much for the quick reply!
I have the latest version and I have looked at the “Manage List Columns” in the Admin Menu. My problem is that I use the short-code on different pages to show different lists and I don’t want to show all the fields every time as there are a lot of them.I have about 100 fields and I want to only show the fields that apply to a specific page. I thought to also possibly use the groups to try and display only the fields for a specific group but I have made no headway with that either.
Is there a way to display only the columns that I have marked in the Manage Database Fields i.e. If I have marked a column as 6 in the display to only show that column in the list on a certain page. On another page I want to be able to show columns 2,3,4 for instance.
I really hope this makes sense and that I am not completely missing the boat here…
I cannot figure out what syntax to use in the short-code to achieve this.
Greetings from Cape Town.
Your instinct was correct, groups are the way to go here.
I suggest you break your fields up into logical groups so that each of your list shortcodes will be easy to set up. For example, if you have fields that need to appear on multiple pages, put those in their own group. Fields that are unique to a single page will go in another group, etc. Then your shortcodes will be set up like this example:
[pdb_list groups="common,group_a"]
[pdb_list groups="common,group_b"]
Hi Roland,
Thank you for your response. I am attempting to be as clear as I can in my question which is the reason for my rather lengthy response.
I have tried your suggestion with short-codes: (For common read “main” and for group_a read “data_capturer”)
[pdb_list groups=”main,data_capturer” filter=data_capturer=Yes]
[pdb_list groups=main,data_capturer filter=data_capturer=Yes]
In both instances it shows all the fields.
I only want to show the First Name, Last Name and Date Available.
My fields are set up accordingly and numbered 1,2 and 3 respectively.
I have the database in groups.
My problem is in showing some of the basic info fields together with some of the fields from the other groups on different pages on the site. An example would be for me to show some “ Basic and Contact Info” together with some fields from the other groups. Each of the groups has it’s own page where I show some Basic and some other fields.
My problem is restricting what I show on each page.
Currently it just shows ALL of the fields that I have marked in the display column on the “Manage Database Fields” screen. If I can find a way of limiting those fields then I have solved the problem…
An example would be for me to only show the following fields:
First Name Last Name Available From Training Certificate Y/N
So on the page for Data Capturers I only want to show
First Name Last Name Available From Training Certificate Y/N
I truly appreciate your assistance in this as I am at my wits end here on the southernmost tip of Africa.
OK, you will need to use the “fields” attribute of the shortcode…for example:
[pdb_list fields=”first_name,last_name,availability” filter=”data_capturer=Yes”]
That attribute can be any list of fields, so you can have different configurations where needed.
Be sure to use quotes around the value of the filter attribute.
It works! thank you so much for your assistance. You are an officer and a gentleman and there are not many of us left…If ever you find yourself in Cape Town…
