Keyword search or indexing in reference field

[Thomas98]

Keyword search or indexing if I may call. 

I have a reference field, which is referenced to the building table. Our company have over 120 buildings.

The name field in the building table has the building number and the actual name of the building. (example: Building 121 Pegasus)

The end user either knows  the building by its number or the name. I know if I use *Pegasus it would show up in the search, but the end user doesnt know that. 

Is there a way to make the search smarter? Either you enter the building number or name and relevant records show up? 

[bammar]

If there is no way to make wildcard search by default.

If this is a catalog item you could put a label  on the variable that always show- search with * for better results

If this is on a form i assume it is for licensed users and thus you could provide this wildcard search in their training. 

Finally if there is another easier to search field you could change the display in the reference. 

[ChanakyaMekala]

You can configure user preferences for it, for example if your referenced table name is u_buildings

then you can create a user preference like this:

Name: u_buildings.autocomplete.contains

Type: Boolean(true/false)

Value: true

System: true

User:<should be empty otherwise it would work for that user alone>

Please mark it helpful if it helped you