I used ENUM and Valid If to create dependent dropdowns based on the user’s email and some previous entries on a different dataset. So far so good. This sometimes (correctly) results in only one choice on a dependent dropdown. When this happens, I would like to just auto-select that choice so that the user doesn’t have to click through dropdowns with only one choice. Any suggestions?
Thanks in advance,
A Perpetual Newbie
To do this, you’ll need to reproduce the behind-the-scenes logic that dependent dropdown use to cobble together the lists. It’s not trivial.
Well that doesn’t sound good, ha ha. Guess I’ll save the advanced stuff for when I become more advanced. In the meantime, the users can stand to click a few extra times. Thanks for the reply.
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |