AnsweredAssumed Answered

Autocomplete & pulldata()

Question asked by Ayelet123 on Aug 23, 2017
Latest reply on Aug 24, 2017 by Ayelet123

How can I set the autocomplete to return results from the beginning of the string only? Is there anything similar to find/substr?
I'm pulling street names from a CSV file that contains hundreds of records.  pulldata('Streets','ROAD_NUMBER','ROAD_NAME',${roads})


When I search for a street name I get all the values that contain the string that I'm typing and sometimes I have to type 5 characters before I can get to the street name I needed.
See the attached screen shot - I was looking for Montgomery street and got 40 irrelevant results, and to get to Montgomery I had to type 5 characters  "montg".

Attachments

Outcomes