If your auto-complete for reference fields is behaving badly — meaning doing a search in one field pulls up words that contain the text while another field gives you results that start with the same text — this might be because you need to update your auto-complete query settings.
By default, all reference fields use the starts with query to search for matching text in the reference table. To avoid inconsistent queries, you can require all reference fields to use starts with by setting the glide.ui.ref_ac.startswith system property. This will disable any contains searches.
To set the auto-complete property for reference fields:
- In the navigation filter, enter sys_properties.list.
- In the Go to Name search, enter glide.ui.ref_ac.startswith.
- Click the name link for the glide.ui.ref_ac.startswith property.
- In the Value field, replace false with true.
- Click Update.
(Note that setting this property to true overrides auto-complete query settings for all users regardless of preferences.)
If you are not receiving any auto-complete search results, you may need to check the System Dictionary entry to see if it's configured properly. If there is a similar or the same field on another form that is working, you can compare the two dictionary entries to find inconsistencies. For more information, see Auto-complete suggestions do not work when typing a value in a reference field.
For more information about auto-complete reference fields, see Auto-Complete for Reference Fields.
8 Comments
