I am building a form. After an Advisor is identified (slice USEREMAIL()=[Advisor Email]), I would like the AppSheet to present that use with a list of clubs associated with that user.
Please help. Thanks!
โ
Solved! Go to Solution.
If it goes to an Enum or Enumlist, maybe something like..
SELECT(Table[Monday Club],[Advisor Email]=USEREMAIL()) + SELECT(Table[Wednesday Club],[Advisor Email]=USEREMAIL()) + SELECT(Table[Friday Club],[Advisor Email]=USEREMAIL())
If it goes to an Enum or Enumlist, maybe something like..
SELECT(Table[Monday Club],[Advisor Email]=USEREMAIL()) + SELECT(Table[Wednesday Club],[Advisor Email]=USEREMAIL()) + SELECT(Table[Friday Club],[Advisor Email]=USEREMAIL())
Fantastic! Thank you!
You're welcome!
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |