Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Re: Conditional Multi-Select Fields

It's not possible to use a multi select field as a Conditional Drop Down filter.

I see two options. 

One option is to drop that approach and set and set up a many to many relationship between a table of those Multi Select  values and the exams. That will take some set up work to load up all the assignments in that middle join table. 

The other approach would be to use a technique I call the User Focus technique which would allow the user to launch off a record to set the focus for that user and then land the user on a filtered list of qualifying exams. That would require a 1 hour one on one session to get that working.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

1 Reply

Sort By
  • Francesco_Achil's avatar
    Francesco_Achil
    Qrew Member
    5 years ago
    Hi mark,
    thank you for the quick reply, to which I was not as fast to get back to...
    Given what you say, I think the easiest right now is to go with a simple list, it will be more difficult to maintain, but the many to many relation is not really the best UX for my usecase and from what you describe, neither would be the second technique.
    I think what I will do will be to use a field named such as "Category - Exam" so that the user can type the category to "act" as a quick filter for the list (or directly the exam name). It's not ideal, because the category will also be saved in the field, and it's not needed, but probably the easiest way to handle it.

    ------------------------------
    Francesco
    ------------------------------