How to update a dropdown object at Design time ( not Runtime)

[aufer]

All:

I have created a form with a drop-down object for Employee.

The additions & removals of Employees from the list is manually entered by an Administrator.

Is there an easier way for this to happen ( from an SQL , Excel sheet ) ?

This needs to be updateable only by the Administrator ( Design time ).

... who will post it to a common directory for the end-user ( who should not have access to the SQL/Excel  & should not be able to modify the list.) to fill.

What I am looking for is a simple process : (a) Admin opens the document (b) Clicks a button that updates the drop down list & (c) Saves it to the common directory.

Aubrey

[_Bruce_Robertson]

Hi Aubrey,

At design time you can paste the values of a drop down list from a text file or an Excel spreadsheet.

I think this was added in ES2.  Instructions are here LiveCycle ES2 * Adobe LiveCycle Designer ES2

Hope they help

Bruce

[aufer]

Bruce ,

Thanks for the link.

Gave it a try but it does not work as documented.

Step 3 does not give me a Paste - Just the Add Item.

Even tried unsuccessfully to paste in the List Item (b)

I am using LiveCycle Designer ES v 8.2.1 - Maybe they fixed in ES2 ?

Aubrey

To add items from Excel or text editor

1. Select the drop-down list or list box.
2. Do one of the following actions:
   • In Excel, copy the spreadsheet cells that contain the text (or text and value pair) you want in the drop-down list or list box.
   • In a text editor, copy the text (or text and value pair) you want in the drop-down list or list box.
3. In the Object palette, click the Field tab, and then click Paste .

[_Bruce_Robertson]

Hi,

I do recall this being added in ES2. 

I think your best bet would be to upgrade.  Designer ES3 has a lot of improvements.

Regards

Bruce