inRange()

inRange(a;b) returns 1 if the number a is within the number range b, e.g. "1-10;15".

inRange([Bib];"1-10;15") - returns 1 if the bib number is between 1 and 10 or equal 15.

isNumeric()

isNumeric checks if a string contains only the characters 0,1,2,3,4,5,6,7,8,9:

isNumeric("12323") - returns true

isNumeric("12W44") - returns false

isAlpha()

isAlpha checks if a string only contains the characters A-Z/a-z:

isAlpha("ASKdeo") - returns true

isAlpha("Ström") - returns false

isAlpha("K3") - returns false

hasChip()

hasChip(transponder) returns 1 if the given transponder code is assigned to the participant, and 0 otherwise.

hasChip("NUSPW44") - returns 1 or 0

The transponder can be assigned by the fields Transponder1, Transponder2 or by the Chip File.

ChipFileHas()

ChipFileHas(transponder) returns 1 if the given transponder code is present in the Chip File, and 0 otherwise.

ChipFileHas("ZABCD12") - returns 1 or 0

search()

search(a;b) returns 1, if all words of b occur in a.

search("This is a string with race and result"; "race result") - returns 1

search("the first three characters of the alphabet do not occur in this text"; "abc") - returns 0

isUCICode()

isUCICode checks if the first parameter is a valid UCI code:

isUCICode("GER19810312") - returns true

isUCICode("Ger13333") - returns false

isUCIID()

isUCIID() checks if the first parameter is a valid UCI ID:

isUCIID("98387437864") - returns true

isUCIID("ABCD123") - returns false

hasEntryFee(entryFeeID)

hasEntryFee(entryFeeID) returns 1 if the given EntryFeeID is applied to the participant, and 0 otherwise.

hasEntryFee(1) - returns 1 or 0

You can find the EntryFeeID under Main Window > Entry Fees.

This function can be used for example as a filter in Output lists, to see which participants a particular Entry Fee has been applied to.

isEligible()

IsEligible(a;b;c) returns 1 if the participant is eligible for the contest according to the date of birth ranges and, optionally, gender, and 0 otherwise.

isEligible("01/01/2000") - checks whether the date 01/01/2000 is eligible for the current contest of the participant.

The function can also take a year instead of date.

isEligible(2000) - checks whether the year of birth 2000 would be eligible for the current contest of the particpant.

The second parameter is optional and can be used to also check whether the gender is eligible for the contest.

isEligible([DateOfBirth];"m") - checks whether the current date of birth and the gender Male is eligible for the current contest of the participant.

The third optional parameter can be used to define the contest ID.

isEligible([DateOfBirth];[Gender];2) - checks whether the participant is eligible for contest ID 2.

This function is useful for registration of relay teams where additional team members information may be stored in additional fields, but you still need to confirm their eligibility to compete.

isValidEmail()

IsValidEmail() returns 1 if the string represents a valid email address, and 0 otherwise.

isValidEmail("john.doe@gmail.com") - checks whether john.doe@gmail.com is technically a valid email address (not necessarily an existing one).