Have you ever had a text field that you wish was.... More consistent? Maybe like a listselect field?
It's something that comes up now and again and is easier than ever.
This helpful little snippet is in our Community Repo, or can be invoked with this oneliner, below.
pwsh -NoProfile -ExecutionPolicy Bypass -Command "irm 'https://raw.githubusercontent.com/Hudu-Technologies-Inc/Community-Scripts/main/Administration/Listifying-Text-Fields/Listify-Text-Field.ps1' | iex"First, you can select any layout that has a TextField
Then, you can simply select the field you would like to make a new ListSelect field for as a replacement. All of your data will be carried over to this new field and all unique values will be available in a new list assigned to it!
After you select the desired field you'd like to change over, you'll be asked to confirm-- and if something doesn't seem right, you can exit with CTL+C key combination
After you confirm by hitting enter, it will get to work.
The script will:
grab all unique values for this field in your selected layout
create (or update) a new list containing unique values
add this field to your chosen layout
copy over values from source field to new list field for all assets in layout
And that's it! You may want to confirm things are looking as-expected, and then wrap up by removing the original field. Conveniently, this script opens up the administrative page for your chosen layout and the global asset view for your chosen layout.
Happy Listifying!