I have a massive multiselect field that needs to be in sync with another table, but I don’t want to have to type all the options all over again. Can I copy all the options and past them into another table?
I thought I saw a solution somewhere, but I can’t find it.
As a side note, if you find yourself using the same options in different tables, perhaps consider making a new table with those options as records and using that instead of a multiple select field. The benefit there is that any changes/updates you make to that table will automatically be available to any other table that links to it, plus you can do more useful things with those options like see how many are used, add lookup/rollup fields to pull data from the tables linking to them, etc.
Unfortunately, I already have data in fields. I tried to copy anyway, but the multi-select options did not copy over (only the data did). I thought about your other suggestion and tested it out, but the filter feature I need would not be present if I did it that way. That is unfortunate because making a lookup is so much easier to keep things synced. I already had a separate table for the options as well.
Based on my demo, the target field can’t already be the field type you want. It should be a single line text, which should force both the conversion and adding the desired options when you paste from another field type.