14.23. Lanes

This tab is in the Debug tab.

The Lanes tab is used to place and manage Entries into Races.

Lanes are usually set up automatically by a Progression. You can use this screen to view the lanes that have been set up, or to make manual changes if there is a problem with the program.

For individual races, one Lane record corresponds to the use of one lane in one race. For group races, each member of the group has a Lane record with the same lane number as the other members of the group in that race; all of these Lane records together correspond to one lane in one race.

14.23.1. Query and Edit Tabs

  • The ID field is the unique ID for this Lane. The default ID prefix is LN.

  • The Entry field specifies the Entry to which this Lane is attached. The Entry record refers to the entrants name via the People table.

  • The Event field specifies the Event to which this Lane is attached, via the Entry and Race records.

  • The Race field specifies the Race to which this Lane is attached.

  • The Lane field specifies the lane number for this Lane.

  • The Result field records the time, distance, or weight for this Lane.

  • The Exception field records the Exception for this Lane, the reason why this competitor was disqualified.

  • The Place field records the finishing place for this Lane; 1 for the first place finisher, 2 for second place, etc.

  • The Score Place field records the finishing place for this Lane among competitors eligible to score; 1 for the first place scoring finisher, 2 for second place, etc. Competitors are non-scoring if they are on a Team for which the non-scoring flag has been set.

  • The Score field shows the team score for this Lane.

14.23.2. Sheet

The Sheet tab allows you to edit the information about multiple Lanes on one page, to simplify entering or editing a group of Lanes.

To edit a set of Lanes, press the "Search" button. A list of all Lanes will appear just below the button.

For more details on how to use the Sheet, see the section on Sheets.

14.23.3. Table

The Person and Event are represented by the entryId field, which references an entry in the Entries table that includes these items.

The remainder of the items are stored in the Lanes table.

ColumnTypeDescription
idStringUnique ID [primary key]
entryIdString The entry included in this race [ref Entries(id)]
raceIdString The race of which this lane is a part [ref Races(id)]
laneint The lane or starting position for this lane, or a negative number as a BYE or OUT indicator
resultfloat The result time, distance, weight, etc. for this entrant in this race.
exceptionIdstring The reason this entrant did not finish this race [ref Exceptions(id)]
placeint The finishing order of this entrant within the race.
scorePlaceint The finishing order of this entrant within the race among competitors eligible to score.
scorefloat The team score for this entrant in this race.