I'm designing a web application where a user needs to add more then 15 football players in a list. For each player user needs to enter values in 8 different fields in each row. It is usually about 50% of all players with no values for any of the fields.
The columns (will be replaced by icons) are:
- Number: 1-99
- Goals: 1-20 number of goals
- Assists: 1-20 number of goals
- Yellow: 1-120 minute
- Second Yellow: 1-120 minute
- Red: 1-120 minute
- In: 1-120 minute
- Out: 1-120 minute
My questions are this:
What is the best way for user to enter a value in my case? Keyboard, numeric-stepper...?
How to mark for users that they need to enter a number of goals/assists and not a minute when a goal is scored what is usually users first assumption?
Some other suggestions for design?