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 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
------------------------------
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.
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.
- Austin,
Thanks for the response! I didn't explain my question well enough. I'm now calling the new table with several 100 options to populate a multi-select text field in a separate table. I am trying to import data into this separate table. The data that I'm trying to import contains a record ID field and the multi-select text field from the separate table (each entry separated by a semicolon).
Am uploading a photo of the error that comes up when I hit upload.
Thanks
-Harrison
------------------------------
Harrison Ray
------------------------------- 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
------------------------------
