Conditional Multi-Select Fields
Hello, As per title, I'm trying to have a record with a multi-select field with a conditional content. I've been able successful in using conditional dropdowns to create relations such as https://h...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt'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
------------------------------
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
------------------------------
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
------------------------------
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
------------------------------