For a change that I needed to make immediately, outside of business hours, I had to come up with an alternative: ChoiceGroupUpdateHack.js
When this script (making sure the code is prefixed with
javascript:) is entered into the address bar and executed, a small textarea element is created at the top of the page along with an Update Values button.
To use the hack UI, all one has to do is paste new values directly from Excel into the textarea element and then click the button!
The Excel spreadsheet should be formatted as it is exported from ApplyYourself. The spreadsheet should include the following columns, in order:
- Choice Value
- Choice Code
- Choice Order
- Header: "Yes" or blank
- Related Value
- Inactive Date: MM/DD/YYYY
Although this hack took 3 hours to develop, the ability to mass update choice groups on demand autonomously is priceless to me.
Note: If ApplyYourself starts throwing bizarre errors that don't make sense, another hack may be necessary to clear the choice group before loading the new values: ChoiceGroupClearHack.js
This hack was validated in Safari 5.1.2 and in Google Chrome 16.0 on Mac OS X Lion.
