• Resolved gavinwatts

    (@gavinwatts)


    Hi Roland,
    Thanks for a great plugin. I have read the documentation but cannot solve my problem. I use [pdb_list filter=data_capturer=Yes] to list all my data capturers and it works great. How do I modify this shortcode to show only certain data columns in the list? I have numbered the columns in the Display Column. I only wish to display columns 1-6. There are many other columns which I have also numbered but do not wish to display. In essence I guess I want to override the display column setting and only show some fields.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author xnau webdesign

    (@xnau)

    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.

    Thread Starter gavinwatts

    (@gavinwatts)

    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.

    Plugin Author xnau webdesign

    (@xnau)

    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"]
    Thread Starter gavinwatts

    (@gavinwatts)

    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.

    Plugin Author xnau webdesign

    (@xnau)

    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.

    Thread Starter gavinwatts

    (@gavinwatts)

    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…

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[pdb List] Column Display’ is closed to new replies.