Make a multiple choice record conditional on other information

Question

I have a multiple choice record with about 50 choices right now. It is very clunky to use, obviously. However, I have found that most of these choices fall under certain categories.

Is there any way to select a category, and then select a choice based on the options that fall under that category? Maybe if all the choices contain the category name in them or something?

I realize this is a bit open ended. Any other suggestions to improve this workflow would be appreciated.

Thanks

quickbasecoachd · Answer

I suggest searching for help on Conditional drop down https://help.quickbase.com/user-assistance/conditional_dropdowns.html

Make a table of choices. You would need to populate the choices table by copying the choices from the multiple choice field and importing off the clip board into the choices table and then set the key field of the choices table to be the text choice value. Add a field for the category.

Typically, this is set up by having a table of categories (I suggest a Key field of the category). That way it would be easier to maintain going forward. So then you would make a relationship where 1 Category has many Choices and then assign the Choices to a category in grid edit.

Make a relationship where a Category has many Records.

Make a Relationship where 1 Choice has Many records - the actual record in your table. use your existing field for the reference field on the right side of the relationship.

Then set the drop down field to be conditional that after the Category is selected, then limit the choices to one where the category matches the one chosen on the record.

jimlieder2 · Answer

Here's a link on how to set up conditional dropdown fields.&nbsp; Let me know if this is what you were looking for:&nbsp;&nbsp;https://help.quickbase.com/user-assistance/conditional_dropdowns.html

alexgale · Answer

I didn't think it was, because my thing isn't a reference field. Another poster had detailed a way to structure the whole thing as a series of reference fields though.&nbsp;

alexgale · Answer

I'll try this out, thanks. I knew about conditional dropdowns, but since they were for reference fields it hadn't occurred to me to try them out in this situation.

Your suggestions to streamline the process are welcome too.

alexgale · Answer

Having now actually done the process, the suggestions to make the process easier were more welcome than ever. Also, it seems to work great. Thanks a lot!

Forum Discussion

Make a multiple choice record conditional on other information

Related Content

Check one field for multiple conditions

Using Grid Edit to Edit Multiple Records at Once

Conditional formula url

If statement with multiple conditions

Edit Multiple Records at Once with Grid Edit