Expand my Community achievements bar.

issues adding multiple items to a drop down list

Avatar

Former Community Member

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

Former Community Member

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