How do populate adobe livecycle drop down list,

From a data file, like excel,  I'd like to populate a livecycle drop down list with a field,  and then different data pop into a text object.


Building1,  Address1
Building2, Address2
Building3, Address3

In drop downlist, I'd like to list the buildings.   ONce one is selected, I'd like the corresponding address in the datafile to populate a text object on the same page.     Thanks.
Who is Participating?
Dushan De SilvaConnect With a Mentor Technology ArchitectCommented:
Following will explain CSV to array. (Or else let me know exact data format)

Following will show how to show Array on Drop down list on PDF using Adobe Livecycle.
Karl Heinz KremerCommented:
Do you want to do this once (when you design the form), or does the data need to come from a database every time  the user opens the form?
rjablonkAuthor Commented:
For now just need to load the table once but it would be good to know both ways
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Dushan De SilvaTechnology ArchitectCommented:
You can use simply use array, building as key and address as value.

[Building1] ->  'Address1',
[Building2] ->  'Address2',
[Building3] ->  'Address3',
rjablonkAuthor Commented:
Thanks. Can you write sample code line or 2 demonstrating that?   Thx
rjablonkAuthor Commented:

Thanks for your post,  the manual array works great.   I am a little confused on how to create the array from the CSV.

AFter copying the csvtoarray function into my livecycle, I ran the following command from the same page:

var worksite = new Array(CSVToArray( "c:\worksite.csv", "," ));

with the hope that the 5 X 5 csv file would create a similar array in adobe.  Is there an example of using the CSV to Array in LiveCycle that you could show me?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.