Livecycle Designer: Select Specific Record from Excel Table - Working

1. Create Table in Excel:

• You need excel sheet name
• Table Header Name

2. Adobe Livecycle Designer ES2: Set Form Properties

• File-->Form Properties-->Default Tab-->Target version--> Select Acrobat and Adobe Reader 7.5 or later (Version 9 was selected and did not work for me)

If you do not follow the Step 2 then it shows error message: Property command could not be set because doing so would violate the permission settings.

3. Adobe Livecycle Designer ES2: Create dynamic DropDownList from Excel Table

1. Window menu-->Select Data View-->On the Data View pane right click-->New Data Connection--.OLEDB Database-->Click Build Button-->Select Microsoft OLEDB Driver for ODBC Drivers-->Click next-->In the Use data source name select Excel files-->Browse to the folder and select the file-->Select SQL Query and type: select * from [Electric Bicycles$]. Here Electric Bicycles is the excel sheet name. after $ name you can choose the cell range
2. From the Tools Menu-->Select Option-->Select DataBinding-->Check Show Dynamic Properties
3. Add a DropDown list from the standard object library-->Select DropDown list -->Select specify item values-->Select DataConnection and Item and Value
4. From the Window menu--> select Script Editor
5. Now select the DropDown list and type the following code while Show: Change, Language: FormCalc, Run At: Client selected

var sSKUName = xfa.event.newText

var sSKUId = $.boundItem(sSKUName)

xfa.sourceSet.DataConnection.#command.query.commandType = "text"

xfa.sourceSet.DataConnection.#command.query.select =

  concat("SELECT * FROM [Electric Bicycles$] WHERE SKU ='", sSKUId ,"' ORDER BY SKU;")

   

xfa.sourceSet.DataConnection.open()

xfa.sourceSet.DataConnection.first()

nancy.presence = "visible"

Here:
sCategoryName: is the text getting from dynamic DropDownList
sCategoryId: is the value of the DropDownList text
Electric Bicycles: is the working sheet in the Excel file
'""': variable name is used inside single and double inverted comma.
nancy: is a subform name where all the button or text field stay