How to display Employee Number instead of Employee Name for reference variable field?

[prasannakumard]

Hi Team,

I've a reference type field on my record producer. It is referencing to User table.

The field name is: Employee number (Referencing to User table).

I used the following attributes for displying employee number and name. It is working as expected.

ref_ac_columns_search=true,ref_ac_columns=name;employee_number,ref_auto_completer=AJAXTableCompleter,ref_ac_columns_display_value=true

If I enter number in that reference field, it is showing employee name and number in search results and finally, setting the employee name.

------->

But, I need Employee number instead of employee name. I've update display value true for employee number on user disctionary table. But, it is reflecting for all tables.

So, can you please provide the feasable solution for the same.

Thaks & Regards,

Prasanna Kumar

[Allen Andreas]

Set your name display to false instead and keep the number as display true.

If you apply the display true and it's affecting all over, you'll need to do a dictionary override for that specific table instead.

[prasannakumard]

Thank you Allen, But, on user table Name, and Number both display values are false only.

[Allen Andreas]

Hi,

You said you updated the number to display true, correct?

But it's doing that all over, meaning globally?

If so, and you want it to only do it on a certain take, then do a dictionary override, otherwise, the global change to display true will show everywhere.

Then make your name to display false, and again, if globally and you don't want that, then do dictionary override.

[prasannakumard]

Allen, I tried disctionary override of employee number. But, on user table there is no dictioanry override for Employee number. Please let me me know if any possible solution.