Les champs de données concurrents sont spécifiques à chaque entrée.
Les champs suivants peuvent être saisis ou importés pour chaque concurrent.
| Field | Type |
| Dossard | int |
| NomFamille |
string (100) |
| Prénom |
string (100) |
| Titre |
string (15) |
| AnnéeDeNaissance |
int |
| DateDeNaissance | date |
| Sexe |
string (2) |
| Nation |
string (50) |
| Épreuve | int |
| Club |
string (100) |
| Licence |
string (25) |
| Statut | int |
| Commentaire |
string (*) |
| Transpondeur1 |
string (40) |
| Transpondeur2 |
string (40) |
| NumInscription |
int |
| Rue |
string (100) |
| CodePostal |
string (10) |
| Ville |
string (50) |
| État |
string (3) |
| Pays |
string (50) |
|
string (100) |
|
| Téléphone |
string (50) |
| TelPortable |
string (255) |
Les champs suivants sont automatiquement générés par le système lors de la création du concurrent.
| Field | Type |
| ID |
int |
| TitulaireCompte |
string (50) |
| NumCompte |
string (12) |
| NumGuichet |
string (12) |
| Banque |
string (50) |
| IBAN |
string (36) |
| BIC |
string (11) |
| MandatSEPA |
string (35) |
| Coupon |
string (20) |
| Créé | date |
| CrééPar |
string (25) |
| Modifié | date |
|
PosInscGroup |
int |
| IDGroupe | int |
ID
Le champ ID est créé automatiquement lors de la création d'une entrée concurrent. La valeur de l'ID est unique pour chaque entrée concurrent, et ne peut être modifiée.
C'est utile pour mettre à jour des concurrents lorsque vous avez besoin d'un identifiant unique qui ne change jamais, comme par exemple pour redistribuer les numéros de dossard.
Statut
Le champ Statut contient un nombre qui représente le statut du concurrent:
- 0: Normal
- 1: Hors course
- 2: DSQ (disqualifié)
- 3: DNF (abandon)
- 4: DNS (non-partant)
- 5: ne s'est pas présenté au départ
Vous pouvez utiliser le champ dérivé StatutText pour afficher le nom du statut à la place.
Si votre événement requiert d'utiliser des noms de statut différents, vous pouvez créer un champ ou une fonction personnalisée, ou adapter la fonction OuStatut(x).
Notez qu'il n'y a qu'un champ statut par entrée concurrent. Si vous devez définir plusieurs types de statut pour un même concurrent (par exemple, sur une course par équipes, ou par étape), vous pouvez définir les champs statuts sous forme de champs textes supplémentaires.
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 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 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 14 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.
AnnéeDeNaissance et DateDeNaissance
Le champ Année / Date de Naissance de la fenêtre Concurrents peut être utilisé pour saisir une date ou une année de naissance, ou même un âge si l'option Utiliser le champ année de naissance pour saisir l'âge des concurrents (entrée inférieure à 100) est activée sous Paramètres > Concurrents > Options de saisie.
Si vous saisissez ou importez une année de naissance, la date de naissance est définie automatiquement au 1er janvier de cette année. Si vous saisissez ou importez un âge, la date de naissance est calculée à partir de la date de l'événement, et la date de naissance est définie au jour de l'épreuve.
Lorsque vous importez des concurrents depuis Excel, assurez-vous que votre fichier ne contient qu'une seule indication concernant l'âge ou la date de naissance des concurrents.
Le champ DateDeNaissance est formaté selon le format de date de l'événement. Si vous souhaitez l'afficher dans un autre format, utilisez la fonction date().