Adding Rider Information to Race Notes Easily
Post date: Jul 6, 2015 12:19:46 AM
CrossMgr has an ability to add Race Information to the Notes screen in Properties for some time.
For example, {=EventName} substitutes the name of the event.
This capability has been extended to add detailed rider information with three new variables: "Bib", "BibList" and "BibTable". These new variable take a bib number and expand it into rider information from the Excel spreadsheet.
Consider the following example as a Note:
A warning to the following riders for improper number placement:
{=BibList 131, 122, 187}
On the web page, this will result in:
A warning to the following riders for improper number placement:
131: SMITH, Reginald, ON4325, USA19930404, Cranked Up
122: COOPER, Raj, ON3224, CAN19910502, Kicking Asphalt
187: SKZYPCZAKM, Szymon, ON1230, POL19930501, Wibatech-Fuji
Much quicker and more accurate than retyping this information. And, if you need to correct something, just change it in the Excel sheet and regenerate the html page.
If a field is not present in the Excel sheet (for example, no UCI Code), that field does not appear in the output.
The {=Bib 131} variable makes an in-line substitution of a single bib number. For example:
Fine of $20 to {=Bib 187} for littering.
results in:
Fine of $20 to 187: SKZYPCZAKM, Szymon, ON1230, POL19930501, Wibatech-Fuji for littering.
And finally, {=BibTable 131, 122, 187} is similar to BibList, but creates a table instead of a list:
A warning to the following riders for improper number placement:
{=BibTable 131, 122, 187}
results in:
A warning to the following riders for improper number placement: