From the ppSD2 control panel: “Setup” > “Add a Custom Field”

1. Select the number of new fields that you wish to add into the database and click on “Continue”
2. On the next page, input the field information:

• Field Name: Input a name for this field. The field name needs to be unique.
• Type: Select the field type. Click here for more information on field types.
  • Based on the field type that you select, you will have one of more of the following options:
    • Maxlength: The total number of characters that a user can input into a field.
    • Size X: The horizontal size, in pixels, of the field once rendered on the page.
    • Size Y: The vertical size, in pixels, of the field once rendered on the page.
    • Choices: The different options available to the user. This is only available for “select” and “radio” type fields.
    • Value: For a checkbox, the value in the database if the user ticks the checkbox.
• Default Order: This controls where this field will be listed in relation to other fields on the ppSD2 admin control panel. A value of “10” will appear after a value of “2”.
• Description: This is a description for the field that will appear on registration forms. It should clarify what the user should input for this field.
• Encrypt: ppSD2 is equipped with powerful encryption technology that can secure information within the database.[1]. This system is ideal for storing sensitive information.
  • Note that you will not be able to view encrypted information within the database. A simple string will appear as follows:

=A3SFVVblt2blNGe2R3Tqd3X2ZER0lmQJh3ZjZUZnFkS0Flbn91bKlGdMhXazV3TUVGaRFHdG90Sp1mQxFFaNhFR399

A random ID field will automatically be populated in the database with a specific format. Formatting is determined as follows:

Formatting
l (lower case L): Replaced by a lower case letter.
L (upper case L): Replaced by an upper case letter.
n (lower case N): Replaced by a number.

Any other characters will remain the same.

Example The follow value ll-LL-34-GlLnnnn will be generated in the database as any of the following (among millions of other possibilities):

• ge-DT-34-GgK4905
• hr-GN-34-GsR3860
• nw-OG-34-GrT5920

Notice how the 34, dashes, and G remain the same but the other characters are replaced with randomly generated characters and numbers.

A date field is stored in the database as an actual date and time, making processing the information and properly formatting the date at a later time much easier.

Date Order: Controls how the fields are displayed to the user on the page.
Month Type: Controls how the months will be displayed, either in a numerical manner (03 or 05) or as a written word (March or May).
Year Start/End: Controls the year range that is displayed in the year field. Example, if you input the start year as 2000 and the end year as 2008, the “year” field will give the user the following options:

2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008