Add in a multi-select field from a large list of long values.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I am looking to add in a field that is a multi-select using a long list of long values.

I have tried two approaches, both with are insufficient.

  1. By using a normal multi-select field, I get the errors that I can't have more than 50 choices, and none longer than 40 characters each
  2. I added the list to a new table and added a relationship so you could select the appropriate value, however I can't figure out how to make this multi-select.  This approach had the benefit of being able to have a conditional drop-down, based on three categories, to limit the options.

Is there a way to make either of these work?

Photo of Phil

Phil

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
Perhaps if you actually describe the business problem you are trying to solve, I can be more specific, but it sounds like you need to have a many to many relationship as opposed to a multi-select field
Photo of Phil

Phil

  • 0 Points
Basically, the main table I am talking about will be a log of events that happen.  These events need to be categorized based on what they are.  Each event will need to have at least one category, but possibly more.
Once events are logged, I would like to run some summary reports grouping the number of events by category.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
Well, I think then that you will need a many to many setup.

One Event has many Reason Assignments.
One Reason has many Reason Assignments

If you need a way to quick select the reason assignments I can show you a demo of a technique for that.  That would be of benefit if you need to quickly select multiple Reason Assignments to add to an Event.
Photo of Dinesh

Dinesh

  • 484 Points 250 badge 2x thumb
Phil, I guess second approach is the most suited one for you, since you have the requirement of having more than 50 choices and each one with more than 40 characters (this is a limitation in the newly introduced multi-select field type). 

While using second approach, you would have seen a button and a report link created to show the records for the new table. Instead of clicking on the button that will redirect to a new page to select an option, you can make the report link editable by checking the "Editable" checkbox in the form settings page. This will show the report link in Grid edit view. You can select multiple options by selecting one option per row in the grid edit view. 

The only downside of using this approach is that, it does not look-like the multiple select dropdown.