The Participant Data Fields are specific to each individual participant record.
The following records can be entered or imported for each participant.
| Field | Type |
| Bib | int |
| Lastname |
string (100) |
| Firstname |
string (100) |
| Title |
string (15) |
| YearOfBirth |
int |
| DateOfBirth | date |
| Gender |
string (2) |
| Nation |
string (50) |
| Contest | int |
| Club |
string (100) |
| License |
string (25) |
| Status | int |
| Comment |
string (*) |
| Transponder1 |
string (40) |
| Transponder2 |
string (40) |
| RegNo |
int |
| Street |
string (100) |
| ZIP |
string (10) |
| City |
string (50) |
| State |
string (3) |
| Country |
string (50) |
|
string (100) |
|
| Phone |
string (50) |
| CellPhone |
string (255) |
| Language (See additional info below) | string (2) |
The following fields are automatically generated by the system during creation, see additional links for more information.
| Field | Type |
| ID |
int |
| AccountOwner |
string (50) |
| AccountNo |
string (12) |
| BranchNo |
string (12) |
| Bank |
string (50) |
| IBAN |
string (36) |
| BIC |
string (11) |
| SEPAMandate |
string (35) |
| Voucher |
string (20) |
| Created | date |
| CreatedBy |
string (25) |
| Modified | date |
|
GroupRegPos |
int |
| GroupID | int |
ID Field
ID is a field that is filled automatically with a unique number when the record is created. The field value cannot be changed.
It is useful for updating participants using a unique identifier which does not change, for example if you want to manually re-assign bib numbers.
Status Field
Status holds a number that represents the status of the participant:
- 0: Regular
- 1: Out of competition
- 2: DSQ
- 3: DNF
- 4: DNS
- 5: did not show up
You can use the derived field StatusText to show the status name instead.
If you need to use different status descriptions than the standard ones, you can set up a user-defined field or function, or adapt the existing WithStatus(x) function.
Note that there is only one Status field per participant entry. If you need to define different status values (e.g. in a team event, or in a stage race), you can use Additionnal Text Fields to set up further status fields.
Language
The language field is used when Sending Emails and SMS through RACE RESULT 12, to determine which lnaguage version of the template should be sent, if a multi-lingual template is used.
The Language field is automatically filled when a participant registers using the Online Registration with the language used in the form at the time of registration. The field can also be filled when importing participants or edited using data manipulation.
The default language field will take higher priority than any additional fields added with the same name (including translated versions).
Additional Fields
Using Additional Fields (previously ATF/AYN/AYNTF) you can customize the data structure for your events and create custom fields for storing any additional participant data. The additional fields can store either text values such as emergency contact details, t-shirt options etc., or are used as a checkbox, storing either 1 or 0 (Check / Unchecked) most commonly used for a Yes/No option.
Additional fields can be accessed in Outputs by using the field Name which is defined in the setup.
If your file contained ATFs, AYNs or AYNTFs in an Event File created in RACE RESULT 12 version below 12.1.0, the respective value will be saved in an internal field and these fields can still be called with ATFx/AYNx/AYNTFx.
If an additional field is deleted then any data stored in that field will also be deleted.
Type
The type determines how the data will be recorded in the Participants window and on-site / online registration. Certain Type selections enable further settings like the option for selection values or Placeholder.
- Text Box - free text entry field
- Drop Down - creates a drop down using the selection values defined.
- Check Box - a single check box which can be either check or unchecked, returns either 1 or 0.
- Number (Integer) - accepts integers only (whole numbers), any decimal values will be truncated, values are returned as numbers.
- Number (Decimal) - accepts any numerical value, values are returned as numbers.
- Currency - accepts any numerical value, values are always returned to 2 decimal places with the event currency unless used in a calculation.
Name
The name is used to identify the field in the event file, names should be short and precise name.
The name can only consist of letters and numbers, no spaces or special characters are allowed. The name is only for internal reference so should be kept as simple as possible, this will not be seen by participants. The name is common for the whole event file no matter which language you use.
Label
The label is the description of this field and will be used in the participant window and by default in the online registration. It can contain blank spaces and special characters. For multi-lingual files you can adjust the label for each language.
Selection Values (separated by semicolon)
This option is only enabled with the Type Drop Down. Enter all selection values separated by semicolons. If the default selection should be blank, start with a semicolon. For example ";Red;Green;Blue" would produce 4 options - blank, Red, Green or Blue.
For multi-lingual selection values, put braces around one selection value, enter the language code and separate languages by a pipe. More information on multi-lingual registrations here.
Additional Field Details
To enter some more details about a Field, click the additional settings button on the right and a pop-up will open with the following settings:
- Active: By default this is enabled. Only active fields are shown in the participant window and can be called in the form fields for the Online Registration.
- Mandatory: Define whether a field is mandatory and must not be left empty or unchecked. The setting in Main Window only refers to data entered in the Participant Window. It does not affect the Online Registration settings.
- Default Value: Enter a default value for Text Fields, select one of the pre-defined values for a Drop Down, or tick the box for Check Boxes to apply this as a default for new participants. This settings affects Online Registration and will there be used as a default field as well.
- Placeholder: Only active for Text Fields. The Placeholder will be shown in grey in the Participant Window and can be used as a hint for what text to enter.
Organisation of Additional Fields
Additional fields can be setup in different groups with their own unique header. When creating a new group you should define a header for the group, each group will be shown individually in the Participants Window with the corresponding name of the group.
Additional fields can be sorted using a drag and drop, and can also be moved between different groups in the same way. The drag and drop is available when hovering to the left of the Type selection.
Participant Creation Fields
RACE RESULT 12 sets Created automatically to the timestamp when the record was created. Modified is set automatically to the time when the record was last modified. The values will be formatted according to the event date format. If you would like to show them in a different format, use the date() function.
CreatedBy is set automatically to the name of the user who created the record. If it was an online registration, it is set to "OnlineReg". The Online data field returns a 1 if the participant registered online, otherwise, it returns 0. The field values are also shown in the top right corner in the Participants Window.
GroupRegPos saves the position of each participant within a group registration. GroupID is a unique ID which applies to all registered participants from the same group. Individual registrations also receive a unique group ID.
Theoretically, these fields can be overwritten using a Data Manipulation.
The ChangeLink is a link that can be sent to a participant for them to change their registration data on their own. The changeID parameter of the URL of the ChangeLink corresponds to the GroupID. All participants from the same group have the same ChangeLink. These fields can be modified with a data manipulation.See Online Self Service for more information.
YearOfBirth and DateOfBirth
The Year / Date of Birth field in the Participants window can be used to input a year of birth, a date of birth, or even an age if you activate the option Suppose input is age, if year of birth <100 under Main Window > Participants > General.
If you type or import a year of birth only, the date of birth will be set to January 1st in that year. If you type or import an age, the year of birth will be calculated based on the event date, and the date of birth will be set to the event day.
When importing via Excel, make sure to have only one field in your file with an indication of age, date, or year of birth.
DateOfBirth will be formatted according to the event date format. If you would like to show it in a different format, use the date() function.