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.
