# COVID-19 for Sports League

**URL:** <https://community.glideapps.com/t/covid-19-for-sports-league/15655>\
**Category:** Ask for Help\
**Created:** [September 11, 2020, 6:18pm UTC](https://community.glideapps.com/t/covid-19-for-sports-league/15655 "2020-09-11T18:18:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MPOster](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mposter/32/9934_2.png) [@MPOster](https://community.glideapps.com/u/MPOster)\
**Post date:** [September 11, 2020, 6:18pm UTC](https://community.glideapps.com/t/covid-19-for-sports-league/15655/1 "2020-09-11T18:18:29Z")

</div>

I am making an app for coaches to check in players at each practice but having problems with sheets to choices. I want the coach to choose his division where the players name will be populated to other questions… what is the formatting for that from sheets to data?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 11, 2020, 9:42pm UTC](https://community.glideapps.com/t/covid-19-for-sports-league/15655/2 "2020-09-11T21:42:32Z")

</div>

I’m not quite clear about this, can you share some drafts of what you want it to look like?

---

<div class="post-metadata">

**Author:** ![MPOster](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mposter/32/9934_2.png) [@MPOster](https://community.glideapps.com/u/MPOster)\
**Post date:** [September 13, 2020, 5:18pm UTC](https://community.glideapps.com/t/covid-19-for-sports-league/15655/3 "2020-09-13T17:18:54Z")

</div>

Sure and thanks …

 ![Capture2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/eaf8e5e4d0b3116fdfebd792ca6de8ac055ce986.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 14, 2020, 12:42am UTC](https://community.glideapps.com/t/covid-19-for-sports-league/15655/4 "2020-09-14T00:42:39Z")

</div>

So I think the structure should be.

A “Players” sheet where you have the players name and division.

In the screen where you want to put the form for questions, create a choice component pointing to a column where you have all unique divisions, and writing to a user-specific column.

Then in the second choice component, filter the players by the chosen division. This choice component writes to another user-specific column.

If the name is not listed, allow the user to use a text entry to write to that same second user-specific column.

Finally, when division & player entries are both not empty, show the form to answer questions writing to an “Answers” sheet., collecting the player’s name and email of the parent via columns component & special component, respectively.