Dropdown based on user

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!

Screenshot 2024-03-12 at 10.00.22โ€ฏAM.png

โ€ƒ

Solved Solved
0 3 91
1 ACCEPTED 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())

View solution in original post

3 REPLIES 3

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!

Top Labels in this Space