How to Format Data Fields for Sitting Labels

ROES Events and FLOW Label Fields

The complete list of data heading fields that will automatically print for all ROES and FLOW Labels is listed below

Important Notes on Field Names:

  • For field name headings, ONLY use letters, numbers, underscore, and space.

  • Do not use special characters in the field column headings. The order cannot be printed with special characters in the column headings.
    ○ e.g. Height can be entered as Height but not [ft' in"] as the header in the spreadsheet. Data within the spreadsheet can be entered with special characters, but not headings

  • Do not use SubjectID or OrderID as field headers, they are reserved fields and using them in your data will break the order submission

Fields Printed on Labels by Default:

Sports HeadingsSchool Headings
firstfirst
first namefirst name
firstnamefirstname
lastlast
last namelast name
lastnamelastname
namename
addressaddress
contactcontact info
studiostudio info
coachclass
divisiongr
eventgrade
grgroup
gradehome room
grouphomeroom
idid
leaguelevel
levelonline code
online codeorganization
organizationorganization name
organization nameorganization_name
organization_namepackage
packagepackages
packagesproject_name
packagesummaryreorder code
playerschool
player Nameschoolname
player_nameschool name
playernamesequencenumber
players Namestudent id
player's namestudentid
project_nameteacher
reorder codeteachername
sequencenumberteacher name
student idticket code
studentidticketcode
teamweb
team nameyear
teamnameiqOrderID
ticket codecontact
ticketcodeJob Title
webLeague Name
year
sport
contact info
Job Title
League Name