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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

issues adding multiple items to a drop down list

Avatar

Level 1

I am working on a form and it's been a long while but I have a sreadsheet with over 1000 items listed that I want to use to populate a drop down list. I only see a way to add one item at a time. What am I missing?

Thank you,

Alison



5 Replies

Avatar

Level 10

Hi,

you can paste all items at once into a drop down.

Open you spreadsheet in Excel and select the desired cells.

Press Ctrl + C to copy the contens to the clipboard.

Now select your dropdown box in Designer and click the "Paste from clipboard" icon in the field palette (right above the list with the elements).

1.png

Avatar

Level 1

I do not have a clipboard.

I have Adobe Pro 9 with Life cycle Design ES8.2.is my version too old?

Thanks,

Alison

Avatar

Level 10

8.2 is indeed to old I'm afraid.

You'll have to upgrade or enter every item manually, sorry.

Avatar

Level 10

8.2 is indeed to old I'm afraid.

You'll have to upgrade or enter every item manually, sorry.

Avatar

Level 8

Is the spreadsheet software you're using Excel?

Kyle