Conditional Multi-Select Fields

Question

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://help.quickbase.com/user-assistance/conditional_dropdowns_basic_setup.html.
However that only allows for a many to one relation.

I'd need to have a field where I can select multiple types of "exams" for a single record.
The multi-select text field with the "populate from another field" option, is perfect for what I want to do, as I do not need linking to another table, just using a central table to manage all possible exams.

However each exam is linked to a category, and there are lots of them, as such I'd be able to filter the multi-select text field using the category, is that possible somehow?

Many thanks
Francesco

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

MarkShnierYou · Answer

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

Sign up

Login to the community