Calculation Fields in Participants Database provide a way to generate field values based on data in the record. A prime example is the “age” field, which shows a person’s age based on their birth date and calculated against the current date. Another example would be a field that shows an average value from a list… (read)
If you want to start with a clean slate on Participants Database, you need to reset the main database table. One way to do this is to use phpMyAdmin, an application for managing databases. This application is usually available in your hosting control panel: Open the application, select your WordPress database, then select the Participants… (read)
Sometimes it is necessary to place a shortcode where the attributes of the shortcode are set according to the current context. For example, if you need to show a logged-in user the list of records that belong to them, you need to use a dynamic shortcode something like this: echo do_shortcode(‘ First NameLast NameClub RoleCityStateMain… (read)
Update 1/16/19: this plugin had to be rewritten to work with versions of Participants Database later than 1.8.0. I often get questions about how to set up member IDs in Participants Database. It is possible to use the built in “id” or “private_id” fields, but in most cases, you’ll want to be able to generate… (read)
When importing a CSV, it is possible to configure it to match and update existing records. The same process can also be used when a new record is submitted via the signup form. Normally, this is done by matching a single identifying field such as an ID or email address. In some cases, it’s desirable… (read)
The PDb_Template helper class makes setting up a custom display for a Participants Database record much easier in situations where you don’t want to just loop through the values. Sometimes you don’t want to treat each value the same, you want to lay out each value in a way that fits the information better. This… (read)
Sometimes you need to set the default value of a field depending on the context of the form you are using. Or perhaps you know what the field should default to because of which page the form is on or some other factor. This is easy to do using a custom template. If you’re not… (read)
Participants Database uses a “private id” value as a key for users to edit their own record. The plugin uses a short 5-character code for this purpose, it’s not meant to be airtight security, just something impractical to guess. Some administrators may want to use a larger term for their install, and it’s possible to… (read)
