Multi-select fields max 100?

Question

I thought Multi-Select fields would allow more than 100 choices in the list, but its seems there is a max. Is this a change from prior? I feel like it used to allow many more in the list with a max of 20 selections. Does anyone have any ideas on how to get around this if I want a multi-select situation for the same field? I know I can create several Multi-select fields and distribute among those but was looking for a one field solution if possible. Thanks.

------------------------------
Ruby Kapil
rubykapil@wi-finity.com
Wi-Finity, Inc
------------------------------

davidlaycock · Answer

Brilliant - thanks Ruby - Spot on.David------------------------------David Laycock------------------------------

michaeltamoush · Answer

Harrison, I've used the trick to bypass the 100 option limit as well, and also ran into an issue similar to yours. The solution is as follows:The field that is linked to the multi select (the one that has more than 100 options), mirror that on a formula field and link the formula field to the multi-select. So make the formula field [Formula Field for Multi Select] = [Original Field for Multi Select].Before you import, make up a silly rule and put it in your formula field. Comment out your original line and put something like "Fake Text" (so that the only possible option for the multi-select is now, 'fake text').Now do your import, it should work. Then go back and change your formula field back to normal (the mirror).In fact, for anyone using this trick it is good to link your multi-select to a formula field. The reason being, if you ever try to change something in your multi-select field (even just try to change the field name), it won't let you save. It will tell you there are too many choices. If you have it linked to a formula field, you quickly go change your formula field to force it to under 100 choices, make your multi-select field changes, then change your formula field back.------------------------------Mike Tamoush------------------------------

rubykapil2 · Answer

Disregard, I setup a separate table for values------------------------------Ruby Kapilrubykapil@wi-finity.comWi-Finity, Inc------------------------------

davidlaycock · Answer

Hi Ruby,Can I check, please?Are you saying that it's possible to get (and you have successfully got) around the 100 option limit on Multi-select text fields, by using an input type of 'From another field" for the options?Only being able to select 20 items has never been a problem for me.But restricting the list to 100 options has caused me frustration many times.)-:I do use the 'From another field' but I've always limited the number of options to fewer than 100.If this is a way around the limit, then many thanks for highlighting.(-:D------------------------------David Laycock------------------------------

rubykapil2 · Answer

Hi David,I had to setup a separate new Table Buildmaps just to hold the values that I want the user to select from.The new Table is stand alone, no relationships needed.In there is a simple Text field, called Buildmap, set to Unique.I imported all my choices into this Text field.Then in the Fieldmaps field - the field that I want the users to enter their Multi-Select choices, I set type as Multi-Select Text.Then Input "From another field".Select shared field option which then pops up a list of Apps.I selected the same App that Fieldmaps is in because the Table containing all the Buildmaps is also in this same App. The table of values can be in the same App or a different App.Then another window asks you to pick the fieldname and you would select the fieldname that contains all your choices, in my case Buildmaps.I entered 116 choices in Buildmaps and it shows them in my Fieldmaps field and user can select them.I will end up with over 400 values eventually.&nbsp;User cannot add new choices in Fieldmaps, so I set up a button that takes them to "Add a new Buildmap" if they need to update the Buildmap list. I put the button on the form and also in the Table they use for Grid Edit, for convenience.&nbsp;Hope this helps.------------------------------Ruby Kapilrubykapil@wi-finity.comWi-Finity, Inc------------------------------

Forum Discussion

Multi-select fields max 100?

Related Content

Multi-Select Fields with Commas in Pipelines

If Then Else formula with a multi select field.

Checkbox Fields Vs Multi-Select Fields for Tracking

Using multi select field in pipelines

Summary report w/multi-select field