Anonymous, bureaucrat, administrator
7,528
edits
Changes
no edit summary
From time to time it may be necessary to have a long list of items in a drop down list. This is grand for one or two, but we have often seen requests for hundreds of items. So to help make life a little easier, we have developed the mass editing system for answer values.
Location:
Main Menu > Database Form Management > Database Form - Question Management > Question - Answer Values - Mass Edit > Select the campaign > Select the List / Menu
* Each item in the list is separated by a semi-colon ;
* Each value is separated by a comma ,
So an example colour item might be
''Blue,field_0_1,field_0_1,Gorm,;''
So if we have three colours in the list of red, green and blue. The data line would read.
''Blue,field_0_1,field_0_1,Gorm,;Red,field_0_1,field_0_1,Dearg,;Green,field_0_1,field_0_1,Glas,;''
Very quickly you can create a lot of items.
With all this lovely data ready to go just copy and paste it in.
* In Excel, ctrl and the A key. (Select All)
* In Excel, ctrl and the C key. (Copy)
Also, please please ensure that you change the field_0_1 everywhere to ensure it is the actual field ID, or you're going to get green hamsters.
[[Category:Module Specific:Form Management]]