Forum Discussion

RickSatenstein's avatar
RickSatenstein
Qrew Trainee
2 years ago

Getting around 100 limit for multiple select in a field

Hello, I need more than 100 dropdown choices for a field which in turn sets a filter for a dashboard. Is there a way around this QBase constraint? Thanks! Rick ---------------------------...
MikeTamoush's avatar
MikeTamoush
Qrew Commander
2 years ago
Not sure if this will work in your scenario, but worth a shot.

You can set up a table and have each record be one choice (in say Field A). Then Make Field B be a formula that mirrors field A. But don't set up that formula yet.

First, go to your multiselect field and get your list from another field. Select field B. Then go back and set field B to mirror field A.

------------------------------
Mike Tamoush
------------------------------