hello Hive mind, need help with a community tennis doubles app I am working on:
1. 4 Players are selected via enum dropdown players[players]
2. Once the first player is selected, I would like the enum dropdown to now show the name of the 1st player and so on; Player 3 drop down to not show the names of Players 1 and 2.
Data validity tab has players[players]. I have tried adding winner 1<> winner 2 in the data validity tab as line 2 But does not seem to work.
Screenshots of the form and the expression attached.
Your help is much appreciated.
Solved! Go to Solution.
For Player 1: (players[players] - LIST([Player 2], [Player 3], [Player 4]))
For Player 2: (players[players] - LIST([Player 1], [Player 3], [Player 4]))
For Player 3: (players[players] - LIST([Player 1], [Player 2], [Player 4]))
For Player 4: (players[players] - LIST([Player 1], [Player 2], [Player 3]))
For Player 1: (players[players] - LIST([Player 2], [Player 3], [Player 4]))
For Player 2: (players[players] - LIST([Player 1], [Player 3], [Player 4]))
For Player 3: (players[players] - LIST([Player 1], [Player 2], [Player 4]))
For Player 4: (players[players] - LIST([Player 1], [Player 2], [Player 3]))
Many thanks for your help Steve. Worked like magic !
User | Count |
---|---|
28 | |
14 | |
4 | |
3 | |
3 |