Combo box feeding into autocomplete box
I found this statement in an old WebADF thread:
It is possible to have an autocomplete text field filtered by the selected value of a dropdown list, but it is not possible to have a dropdown list filtered by the value of an autocomplete text field.
I've been trying to figure out how to do this and I'm stumped. I started with cascading combo boxes, but this isn't helpful because I have too many records in the 2nd combobox dropdown. I'd like the user to first filter records by type, then use an autocomplete field to search for a string and get only those values that match the string.
It appears that the difficulty lies in passing the variable from the combobox to the autocomplete box--I can't get the autocomplete box to pull in the variable, probably because I'm not sure what syntax to use in the Where Clause. Any suggestions?
-
Hi Steven,
It actually is the opposite that is true. You can have an autocomplete box as the first step, and have subsequent controls (combobox, list box, etc) filter by the value entered in the autocomplete box, using their cascading id field. An autocomplete box currently does not have a cascading id field, so it cannot filter its values based on the control above it, in this case a combobox. We have an improvement listed to include this functionality, and I'll add you name to the request.
-Victoria
0 -
Thank you, Victoria.
0 -
I've got an autocomplete box for which I'd like to filter values according to the selected item in a combo box on the form. Given four years have passed since your post, Victoria, has this functionality yet been added? If so, how do I find it? 0 -
Hi Justin,
I looked up the improvement that Victoria mentioned (SLAPI-365), and it looks like it never did get implemented. That being said though, I would recommend posting this as an Idea in the Support Center if this is something that'd you'd like to see. We might find that this is in higher demand now than it was in the past with older technologies.
Sorry I couldn't have better news on this one.
Amanda0 -
Hello Justin,
I have also re-filed the improvement request internally and added you as a stakeholder. The previous improvement was filed under an outdated category for the Silverlight/WPF API, so adding new stakeholders wouldn't have helped as much. The new tracking number is now GE-8620.
Amanda0 -
Has this feature been added yet? 0 -
Hi Soham,
I've looked into it and there hasn't been any progress yet on GE-8620. I would definitely recommend posting this to the Ideas section (https://support.geocortex.com/GSCIdeas?c=09a6000000008RsAAI&filter=1&categ=all&sub-nav=ideas&main-nav=essentials&page=1) as well to allow other users to vote for it. Doing so usually helps improve the request's visibility.
Thanks,
Amanda0 -
You can't do this with a single form yet, but you can do it with two forms. Here's a sample workflow:
https://drive.google.com/open?id=0B_hHHiqcTKMfMm5JbVBrTWNpX1U
If you want to see it work as is, add this layer to your site:
https://gis.brooklynpark.org/arcgis/rest/services/Public/Places/MapServer/2
Otherwise, you can make it work with your content by changing these default values:
1) mapId
2) layerName
3) formField1
4) formField2
This workflow uses two string fields. If you want to use a numerical or other field type, make sure to adjust the where clause syntaxes accordingly.0 -
Correct me if I'm wrong, but this could be done with the use of a token like {1:FormItemId} e.g. {1:ComboBox1}.
See the item "Tokens in Form Item Queries" in the "About Forms" topic in the Workflow Designer Help.-1 -
@Nico: works like a charm! Thanks so much! 0 -
Credits to Latitude... 0
Please sign in to leave a comment.
Comments
11 comments