Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 16, 2024 03:08 PM
Hi guys,
Hey, guys,
Please help me solve a problem - I have a table of tennis matches, which has fields Player 1 and Player 2, which are linked to another table Players. In the matches table next to the Player 1 and Player 2 fields, I want to add a single select field Winner, which will have only 2 values: Player 1 or Player 2.
Is there a formula that will allow me to create a single select from the values of the neighboring fields?
Thanks.
Solved! Go to Solution.
Sep 16, 2024 03:48 PM
Hello!
You don't need a formula to make this work actually. Assuming you have an identifier, username or fullname in your player records:
Here are some screenshots for the configuration of the lookup fields:
The Matches table:
The Winner field configuration:
Final output:
Sep 16, 2024 06:28 PM
I don't think creating a single select via a formula like that is possible I'm afraid, and I think the best we can do is something like this:
SWITCH(
Winner,
"Player 1" , {Player 1},
"Player 2", {Player 2}
)
---
@EvreuxPendragonthat's a really neat solution!
Sep 16, 2024 03:48 PM
Hello!
You don't need a formula to make this work actually. Assuming you have an identifier, username or fullname in your player records:
Here are some screenshots for the configuration of the lookup fields:
The Matches table:
The Winner field configuration:
Final output:
Sep 16, 2024 06:28 PM
I don't think creating a single select via a formula like that is possible I'm afraid, and I think the best we can do is something like this:
SWITCH(
Winner,
"Player 1" , {Player 1},
"Player 2", {Player 2}
)
---
@EvreuxPendragonthat's a really neat solution!
Sep 17, 2024 12:49 AM
Thank you all guys,
You've been a big help. I'm just surprised I didn't think of this solution myself 😊