I am working on creating a scoring app that allows multiple teams to participate at the same time and have several attempts at each challenge. How can I get a team’s different score submissions entered into their respective row? Scores would be entered at different times throughout the day through a form.
Example:
-
Team A:
Challenge 1:
1st Score 100
2nd score 110
3rd score 105
-
Team B
Challenge 1:
1st Score 100
2nd score 180
-
Team C:
Challenge 1:
1st Score 100
2nd score 110
3rd score 105
I would like for the rows to be set up as follows:
Challenge Team 1st score 2nd Score 3rd Score
1 A 100 110 105
1 B 100 180
1 C 100 110 105
