Multi-select fields max 100?
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...
Forum Discussion
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
------------------------------
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
------------------------------
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.
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.
Hope this helps.
------------------------------
Ruby Kapil
rubykapil@wi-finity.com
Wi-Finity, Inc
------------------------------
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.
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.
Hope this helps.
------------------------------
Ruby Kapil
rubykapil@wi-finity.com
Wi-Finity, Inc
------------------------------
- Brilliant - thanks Ruby - Spot on.
David
------------------------------
David Laycock
------------------------------- Hi Ruby and David,
This method of bypassing the 100 option limit did wonders for me! Thanks for posting. Any idea how to import data from a csv into this new field though? I keep running into an error. I don't think there's a way to import if the multi-text select field calls from a separate table. But would be so happy if that's wrong!
Thanks for any advice.
-Harrison
------------------------------
Harrison Ray
------------------------------- Wow these forums are incredibly slow today. It took several minutes between me hitting "Reply" and it opening the reply box....
In the new table it is just a text field and each entry will be a record so you should be able to import normally. If it doesn't allow you to do it while the field is connected them disconnect the field, import your values, then reconnect. Don't use Record ID# when importing these unless you want to update specific records later on.
That should work. If not, post your error because I am kind of flying blind here without that.
