Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Create many entries "automatically" for List Box

Avatar

Avatar
Level 1
frenchymax
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
frenchymax
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
frenchymax
Level 1

22-08-2012

Hello everyone,

I am encountering a problem when I want to create about 660 entries for a list box. Indeed I followed the instructions reported the topic " Using drop-down lists and list boxes" but the result expected does not happen.

When I copy and Paste, either everything goes into the caption box or only the first entry is taken and not the 659 others, which is, you will understand annoying. (Version 8.2.1.4029.1.523496)

View Entire Topic

Avatar

Avatar
Validate 1
Level 2
past-tense
Level 2

Likes

9 likes

Total Posts

85 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
past-tense
Level 2

Likes

9 likes

Total Posts

85 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
past-tense
Level 2

22-08-2012

Sorry about that...

The only other way I know of is to edit the xml directly. Add a list box or drop down list to your form. Select the field, then click the XML Source tab (next to master pages tab. If it's not there, right click to the right of the preview tab in the gray area and check off XML Source).

XML1.png

Where it says <items save="1" /> you can manually add in items in the following format:

<items save="1">

     <text>Option 1</text>

     <text>Option 2</text>

</items>

you can paste all of your list items into column A in an excel sheet, then put the following formula into B1 and fill down for the length of your entire list:

="<text>"&A1&"</text>"

copy all of column B for a list like:

<text>Option 1</text> 

<text>Option 2</text>

you can then directly paste that into the xml.

User beware, editing the XMl incorreclty can destroy your form. Always backup before you fiddle with xml.

- Scott

Edit: It may be easier to add one item to the list before opening the xml source. This will add the:

<items save="1">

     <text>your manually added value</text>

</items>

to the xml, allowing you to overwrite the "<text>your manually added value</text>" with your list from excel.