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!
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!