"Add Multiple Choice List Items" Tool

[Jim Coyne]

Included in the Developer Toolbox Update Set available on Share (link to Share in the post).

A close relative to the "Add Multiple 'Question Choice' Records" Tool, this one allows admins to quickly and easily add a number of items to the Choice list for a field.

Here is the popup UI Page:

The UI Page has a number of options to choose from:

Option	Description
Table	The physical name of the table.  Defaults to the name of the table the field is defined on.
Field	The physical name of the field the entries will be created for.  Defaults to the name field in the Dictionary Entry record.
Language	The language the entries should be created for.  Defaults to the current language the user has selected.
Dependent value	The value for any dependent value if the field is defined to be dependent on another.  Blank by default.
How is the data separated	Either "Comma-separated string" or "One entry per line".The selection depends on your source data.
Start Order at	The number you want to start the "Order" field at for the first choice item.
Increment by	The number you want the "Order" field to increase by for each new choice item. Leave at 0 (zero) to sort your items alphabetically.
Include NULL option?	If selected, will add a new choice item with a value of "NULL" which will then override the "-- None --" option normally seen.
NULL selection text	This will be the text used when overriding the "-- None --" option.
Use the same string for the 'Value' field	When selected, the strings entered in the text box will be used in both the "Value" and "Text" fields on the Question Choice records.  Otherwise, a lowercase version of the strings will be used, with all non-alpha numeric characters being converted to the underscore character (_).
"Add 'NULL / Yes / No' Choices" button	When clicked, will set the options above to add a set of NULL/Yes/No choices.

And here are the results:

In case you don't want to install the full Update Set mentioned at the top of this post, I've attached some XML files for you to import into your instance:
- the UI Action
- the UI Page
- an Access Control record that allows access to the UI Page
- an Access Role record that only allows the "admin" role to access the UI Page
- UI Message records for all the strings visible to the user

TIP: import the Access Role record before the Access Control record, otherwise the system may add "snc_internal" to the "Requires role" list.

NOTE: Remember, always a good idea to try it out in your company's development instance first, or better yet, your own personal development instance.