I need to create an auto look up box, the process would be as follows, you would type the first letter of a part number in a text box and a row selector would goto the first line in the table that starts with the value typed. Then the process would repeat for each value typed until correct row is found in the table.
Once you have a table with data to search through, add a text field to the window (the search field). Once added, uncheck the Defer Updates property so the component will fire changes while you type. Lastly, add a propertyChange script to the component (by right-clicking and selecting Configure Actions -> select propertyChange) that is the following:if event.propertyName == "text":
search = event.newValue
table = event.source.parent.getComponent('Table')
data = fpmi.db.toPyDataSet(table.data)
rowToSelect = -1
count = 0
for row in data:
sourceStr = row[1]
if sourceStr.startswith(search):
rowToSelect = count
break
count += 1
table.selectedRow = rowToSelect The eighth line selects which column from the dataset you want as the source string (first column is 0, next is 1 and so forth). Hope this helps.