I think so. Here’s an image from an app of mine:
In this app, the “tags” are typed into individual records my the user. Then the app automatically collates all of the tags that have been entered and displays them in this format. So, if the user adds a new tag, it will be added to the list of tags to choose from. When the user chooses a tag, the app displays only those records that have that particular tag. I think this approach would work for you.
My problem is that, I figured out how to do it on my app a long time ago but I can’t find a appropriate sample app for you. Here are some images from my app editor:
I think you’ll want the column type to be “Enum”, the base type to be “text”, and then you can choose the display type you like.
Then, you need to make a formula that makes a “list” of all of the teams (or, a “list” of all of the players on a team) and put that it the Valid if slot:
I hesitate to show the whole expression I made because it’s quite unique to my circumstance and therefore might be more confusing than helpful.
I looked for a good sample app that shows how to do this but could find a good one. I think I need to help. @Steve, @LeventK, @Aleksi . . . can you point us to a good source (sample app or documentation page, etc.) that can help Tiger here. I learned how to do it on my own app earlier this year but I’ve forgotten how I learned.