Restricting name search of a user reference field on Record Producer on a particular form

[sam55]

Hello All,

On a Record producer we want to restrict name search on a filed that has reference to the user table and only able to search with employee number. We dont want to change the display value as it impacts globally. Is there any way we can do this on a particular field of record producer.

Thanks.

[AnveshKumar M]

Hi @sam55 

Have you tried the ref_ac_columns attribute? You can specify the fields to display in the reference variable and the search happens on the same. You can specify ref_ac_columns=your_employeed_id_field_name

Official Documentation says: 

Specifies the columns whose display values appear in an auto completion list in addition to the name. Separate column names with a semi-colon. For example, ref_ac_columns=user_name;email;sys_created_on allows auto-complete to match text from the user_name, email, and sys_created_on columns.