I have a requirement to retrieve around 15,000 values via web service call and display them on Nintex form as option values in a drop down list.
This drop down list needs to sit in a repeating section control so it needs to show on each new row as well.
Options I thought of are below but I was wondering what would be the best one or if you have a better suggestion.
1. Store them in a SharePoint list and use list lookup on the form, however, there is SharePoint limitation of 5,000 records that can be retrieved.
2. Store them in a SQL database and lookup from from. Possible performance issue on retrieval? any limitations? I measured the total size of 15,000 records in string format and it is around 300kb.
3. custom jquery that calls a web service using the first 1-3 letters typed in and display filtered options? This option is preferred one but not sure if it will work in a repeating section control?
Solved! Go to Solution.
to 3: You can use jquery-ui autocomplete widget in repeating section (see http://jqueryui.com/ ).
jquery-ui is as jquery included in Nintex Forms (NWF$).
Look at remote datasource examples and check out http://api.jqueryui.com/autocomplete/
Hi, I tried it today and it is working well, however, it only works for the first row in the repeating section.
any ideas? thanks again.
Hi Brian, I'm having same issues as yours with the autocomplete. It is only working for the first row, how did you manage to fix this issue please if you don't mind sharing. Thank you