By Tukulti65 - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=47436569

Participants Database

This WordPress plugin is for the purpose of creating a simple database for use on a WordPress site. It is primarily intended as a way to manage information pertaining to people such as the members of a club or team, volunteers, students, anything like that. It gives you the ability to create forms that allow people to create and edit their own record while additional information can be managed by administrators or managers.

The plugin may also be used as the basis for an index, directory or catalog.

The database is made up of fields, and each field may be one of several types that are uniquely suited to store a particular kind of information. These fields can also be divided into groups to help organize the information. Fields can also be provided with help text to assist users in filling out the form.

Take a look at this video overview of the plugin contributed by user Fiona Blinco

Plugin Technical Support

Participants Database is a complex plugin and getting the most out of it often requires some basic technical knowledge. There are three main ways I support the plugin: the public forum, the comments section here, and by email.

Please read through the documentation and relevant support conversations before posting questions, you may find your questions have already been answered.

My support email is published in the plugin, please use it if you have questions or links you don’t want made public, or for special requests. While I try to provide good support for free, please remember this is what I do for a living and my time is limited. I am usually available to provide plugin customizations, so please contact me with inquiries about extending the functionality of the plugin.
>>WordPress Plugin Support Forum

2,827 thoughts on “Participants Database

  1. Roland, Hi
    The Plugin is amazing. Thank you for letting us use it free.

    After activation, I had some difficulties of understanding how it really works, but after reading your documentation and putting some thought to it, I managed to overcome almost all difficulties except one.

    In order to get a single record, it is mentioned that I have to visit through a link and the link is to be placed in one of the fields. That means, only a user at the back end can get a single record. My query is, Is it possible to place the link in a page at front end, so that a visitor (non user) can get a single record?

    Hope you understand my problem and thank you for an early reply.

    Gavin

    1. Hi Gavin,

      The link to a single record is typically found in a list of records, which is displayed using the [pdb_list] shortcode. This link is configured in the plugin settings under the “List Display” tab. You select which field in the list is to be clicked on in the “Single Record Link Field” and the page on which the [pdb_single] shortcode is placed is selected in the “Single Record Page” setting.

      I hope that helps clarify how the links work.

      1. Thank you, Roland, for the fast reply, you have a great sense of support.

        I think I haven’t fully described the situation in the beginning, sorry for that.

        Due to confidential nature of my application, I have to do away without the [pdb_list] short code, completely. In other words, a participant should not see other participants in the database at any circumstances. Even though it is possible to limit the list to one record only in the settings, still the participant numbers appear in the list page and a visitor can easily see about other participants by pressing any number. The ideal requirement for my case is to get only the record of the person who accessed the page through a URL.
        I think this can be achieved either by removing the participant number list appearing in the list page (where the Records per page is set to 1, in List Display Settings), or by placing a link in the page where the [pdb_record] short code.is placed, as that is the page a visitor will access through the URL link sent to him by the email.
        I hope it is clear and appreciate if you can suggest a way.
        Thank you for your time.
        Gavin

        1. Hi Gavin,

          It is entirely possible to send the link to the user in an email. Just add something like this to the email template…lets say your [pdb_single] shortcode is on a page named “single-record” so in your email template put:

          <a href="http://your-domain.com/single-record?pid=[id]" >View Your Record Here

          That will give them a direct link to the single record.

          The plugin is not particularly secure in this regard, anyone who wanted to fish around with id numbers wouldn’t have any trouble viewing other records. If you want to secure this aspect of things, you’ll need to add some custom code.

  2. I have a question, can I add a PAY field, I have not downloaded this yet, but I work for a small not for profit and I am trying to make signing up easier along with paying easier.

    1. Michele, the plugin doesn’t have a way to integrate with a payment system, but most of the time, you can get people to pay voluntarily by placing your payment link on a “thanks” page that they go to after signing up. If you really want them to pay, say something like “your application is not complete until payment is received” or something like that.

  3. Hi Roland,

    Thank you for this plugin.

    I have successfully integrated it and it worked fine only that the entry field boxes are not showing the boxes with an outline to make them visible.

    So I thought this might be with the actual theme itself so I contacted the author who sent me this codes which I tried but still wont work.

    But first, please have a look at this link on my website to see what I am on about:

    http://www.dgtal-mind.com/registration/

    and below are the codes the author of the theme sent over:

    “You will need to add to your registration forms the following CSS rules (I hope you can add them somehow inside your plugin menus):

    border: 1px solid #acacac;
    margin-bottom: 1.3125rem;
    padding: 0.7rem;

    Or, you should add “.blog-form-input” CSS class to your your HTML element”.

    Could you please direct me on what to do as I have tried inserting the css code with no luck.

    Regards,

    Anthony

    1. Yes, well CSS can be a bit tricky, the right code in the wrong place won’t work sometimes. You could try to verify that the new CSS rule is getting loaded, but I’d suggest trying it in a couple of other places to see if it works. The first place I’d suggest placing it is in a “custom CSS” setting provided by the theme or another plugin. For instance, JetPack adds an “edit CSS” item to the appearance menu which makes a great place for rules like this.

      The Participants database plugin also has a “custom CSS” setting, it will probably work, but it will only be loaded on pages that use plugin shortcodes.

      1. Thank you Roland,

        yes I will try out your suggestion and see out it plays out.

        But first, please any reason why my Settings page on the Participants database plugin is gone blank?

        1. Anthony, I don’t know what would cause the settings page to be blank. Did it work for you before? Do you remember what you did just before it disappeared?

    2. Oh, and another thing, the CSS rule you were given is incomplete: there is no selector. I’d suggest a rule like this:

      input[type=text] {
      border: 1px solid #acacac;
      padding: 0.7rem;
      }

      you could put that in the plugin settings under the “custom CSS” tab.

      1. Hi Roland,

        Thank you so much. I think what I did was to input the css code I was given in the custom CSS because before I was able to see the settings page on the participants database but now its gone.

        However, the good news is that your version of the css code worked and the outlines are now visible.

        I guess I just got to get back to work now and finish up the form fields and worry about that another time :)

        Once again, Thank you so much.

        Thumbs Up.

        Anthony

  4. Hi Roland.

    Thank you for creating an awesome plugin.

    I have two questions, that I was hoping you could help me with:

    1.) The listing of the participants are not responsive and so the table is off the screen with no scrollbars to move right/left on smaller screens like phones. I have tried using “template=responsive” but then I lose the nice table/grid on bigger screens. Can you help..?? Is there any way to display the regular template for big screens and then the responsive template for small screens…??

    2.) When using a link-text for a web-address field, is it possible to have it open in a new window…???

    Thanks in advance.

    1. If you need the list to be responsive, I suggest you try the “responsive” template. You select the template in the shortcode like this: [pdb_list template=responsive]

      To make links open in another window or tab, you need to use a custom template so you can alter the field’s anchor tag to include the target attribute. You’ll need to be familiar with PHP to do this, take a look at this page for the general instructions for setting up a custom template: Using Particiapnts Database Custom Templates

      You’ll be adding the the target value to the “attributes” property of the field like this: $this->field->attributes['target'] = '_blank';

Leave a Reply

Your email address will not be published. Required fields are marked *