Answered
I have a huge amount of entries to populate a drop down list with. They are currently on a spreadsheet. Is there a way to import them into the drop down list as I don't want to be typing from here to rapture? I have no SQL back end or facility to use and XML mapping.
Many thanks
Then Read these two articles, they'll provide everything you need to know.
http://acrobatusers.com/articles/getting-external-data-acrobat-x-javascript
http://acrobatusers.com/tutorials/2007/js_list_combo_livecycle/
There are other ways to do this, but none are less complex.
Except maybe a tool already created by Try67 for this purpose
http://try67.blogspot.com/2009/11/acrobat-import-text-file-to-drop-down.php
I believe this tool is for AcroForm lists, you'll need to modify it to work with a LiveCycle form. Or if you contact try67, he might do it for a fee.
Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script