Posted on by

Using Custom Format Tags for Calculation Fields

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)

Posted on by

Clearing the Participants Database Table

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)

Posted on by

Generating Unique Member IDs for New Registrations

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)

Posted on by

Adding Fields to the Participants Database Contact Form

The recently-released Contact Button add-on for Participants Database adds a javascript-powered pop-up contact form to any list or single record display. The form is pre-set to include inputs for a name, email address and contact message, but it is possible to add additional fields if you need something more from people who are sending contact… (read)

Posted on by

Matching Multiple Fields with CSV Import or Signup Submission

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)

Posted on by

Adding a Google Map to a Single Record Display

There is now an add-on you can get to add Google maps to Participants Database records and list displays: Location Maps Google Maps offers an easy way to show a location map without needing to register for and use the Google Maps API. This method is available to websites on a limited basis: if you… (read)

Posted on by

Custom Field Validation

Setting up a custom validation method is relatively easy if you’ve got some PHP skills. If you’re familiar with using WordPress filters, then you’ve got the basic knowledge you need to set this up. If you’re not sure what WordPress filters are and how to use them, there is a good intro article that should… (read)