5KM Early Bird

The early bird registration is only available to the first 50 registrations in the 5km, for this we need to be able to compare to the number of participants already registered. The first step of this actually creates a new additional field and entry in our online registration form fields setup. 

We created an Additional Field text box, and then in our form fields setup use the Special Function Calculation (Before Saving). With this we can write an expression to calculate a value based on the participants entered data and participants already registered in the file. 

We used a DCount() to count the number of participants in Contest 1.

DCount("[Contest]=1")

This has to be done before saving so we can refer to this in our entry fees, for which we setup 2 different prices with filters looking at the RegistrationCount additional field. 

As of RACE RESULT version 12.1.6 it is no longer necessary to use val() when referencing Additional Fields which ONLY contain number values.

Family Registration Fees

In the Family Fun Run registration, adults are charged at EUR10 and children at EUR5. For this we create the 2 required entry fees and set the born between upper / lower limits respectively. 

Adults are considered 18 and so can have a date of birth up to 2002-05-06 (with the event dat of 2020-05-06), children are born after this date and so have a date of birth from 2002-05-07 or later.

VIP Packages

We have three VIP packages available which have a fixed price for each, regardless of family group size, we also chose in our online registration setup to save the package selection for all group members so we can easily see how many people we expect at the VIP lounge. 

As we only want to apply the VIP package fee once we have to make some extra considerations to make in our filter, we only applied the fee to the first registration in the group, according to which package they select. When working with multiple filters we can write an if() statement looking at all our variables which returns either a 1 or 0, and then set the filter based on either 1 or 0.

If([GroupRegPos]=1 AND [VIPpackage]="Gold";1)

Here we return 1 when they match our criteria, where the group registration position is 1 and they selected the Gold VIP package.

We then created the corresponding fees for each package where this statement is equal to 1.

T-Shirts

For the single 5km registration we simply apply the entry fee where they tick the T-Shirt Selection Check Box. 

For Family registrations we have 2 considerations to make, did they select the Gold VIP Package (which has free T-Shirts) or how many T-Shirts did they order. 

To first ensure T-Shirts are only charged if they did NOT select the Gold VIP Package we set the basic filter accordingly.

For the cost we set the entry fee to the cost for 1 T-Shirt, and then in the additional entry fee settings use the Multiply With option with the GroupTShirts field which is the number of T-Shirts ordered. If no T-Shirts are ordered then this will return 0 and so nothing will be charged, otherwise the base fee of EUR12.50 is multiplied by the number of T-Shirts selected.

Charity Donation

The charity donation uses the same method as the group T-Shirts, however here we set the base fee to 1.00, which is then multiplied by the value entered in the online registration. The entry fee is only applied to those who ticked the CharityYesNo Check Box.