Missing Dropdown Values

[thecbliss]

I have a Writeback table with a dropdown column using defined options on a field. But when I go to search for certain values, it cannot find them. However I can see those values in a table using the field that defined the drop down options. 

1st edit

Can someone please confirm if it is true that you can only have 10,000 searchable options in a writeback dropdown?

I had to use the wayback machine to follow the link in Qlik 

Vizlib Help Centre | Vizlib Writeback Table - Input Field Options (archive.org)

2nd Edit

It appears that the only fields available to the dropdown are those fields in the scroll window. If I change how options are sorted, what's locatable by searching changes. 

[thecbliss · Accepted solution]

To solve this I created a filter pane and set the writeback table columns to get the appropriate selected value where options file was set to "getFieldValue(filtered_field#)"  and then the add row button got the expression "if(getpossiblecount(filtered_field1)= 1 and getpossiblecount(filtered_field2)=1 and getpossiblecount(filtered_field3),1,0)" so that the button wasn't available until the fields were filtered. One the button is visible and clicked, it autopopulated the fields to the selected filtered field values.