Autocomplete possible with Forms Designer?

[thebrightlord]

Looked through the documentation, did not find anything.

Does Forms Designer have any custom methods or support autocomplete fields on custom forms? By this I mean typing in a few letters then having the field "suggest" values from somewhere, similar to how google does it.

[mnikitina]

Hello thebrightlord,

Forms Designer doesn't have a built-in autocomplete function. But you can adapt the code from this example for Forms Designer:

[thebrightlord]

I was able to get this working. Not on the forms designer fields but on raw html inputs such as textboxes. All you have to do is attach the autocomplete functionality to those like below, then port over the information using javascript to copy the needed information into the forms designer fields for display/manipulation purposes.

Code: Select all

  $(".title").autocomplete({
   minLength: 1,
  source: function (request, response) {
  var term = request.term;
  
  var spUrl = "URL HERE";
  var restUrl = spUrl + "/_api/Web/Lists/getbytitle('Sport')/items?$filter=substringof('" + term + "',Info)";
  
   $.ajax({
      contentType : "application/json;odata=verbose",
 headers : { "accept" : "application/json;odata=verbose" },
  url: restUrl,
  dataType: 'json',
  success: function(data){          
  response($.map(data.d.results, function (value, key) {
  return {
    label: value.Title,
   value: value.Title,
         };
 }));    
   }
  });
 }

});

The code here uses the SharePoint REST api to make a call to the 'Sport' list at the URL HERE location on the textbox with a class named 'title' and is filtering the 'Info' column based on what you type.

The minimum length represents the amount of text typed before the AJAX call is made.

The return code controls what gets returned, that can be edited to fill in other fields simultaneously though its a bit more involved than that, unique names have to be created if you want to return those values and set other fields once returned (e.g. if you want the modified date, it would be modified: value.Modified, and ID would be id: value.ID). Whatever the column name is, it'd be value.columnname with a custom designation in front basically.

This was a good site, with examples of how to use autocomplete, though not SharePoint specific: https://jqueryui.com/autocomplete/
Here is how to use the REST api to filter, sort and much more: https://social.technet.microsoft.com/wi ... -list.aspx

Its quite powerful.