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 |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |