Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.

dropdown list in a barcode form

Avatar

Level 2

Hi,

As I develop my form in LiveCycle designer, I'm setting a drop down list in the form. As seen on the tutorials we have to input the data to for the drop down list one by one.

Can the list be imported from an excel file to make it easier?

Thank you

-Raja-

5 Replies

Avatar

Former Community Member

You can add a list of options to a drop-down list or list box by copying data in tab-delimited form from Microsoft Excel or a text editor.

Note, the data must be in a row format (key-values) rather than a columnar format, as shown below.

p.png

Highlight the applicable cells in the spreadsheet and do a copy (Ctrl-C) to place the data on the clipboard. Go to the drop-down list in Designer and click the clipboard copy icon to paste the keys into the object’s list of items.

p.png

Steve

Avatar

Level 2

Hi Steve,

We have tried to explore pallettes/objects section but we still can't find the icon to paste list from excel

As below,

untitled.JPG

Thanks

Avatar

Former Community Member

I'm sorry. The feature is new in LiveCycle Designer ES2.

Steve

Avatar

Level 2

Ow.. okay...

Can we get the new feature too?

Avatar

Level 1

What steve said truly helped me so much. I considered I was familiar with dropdown list and forms. However, for some part like excel barcode add-in, I don't have much experience. This thread helped me gained some practical information.