How can I interchange the columns Name and Email which are displaying in reference field on Portal

[DP_3105_2]

I am having this requirement where I have to interchange the columns name and email which are auto displaying when we click on reference field. I have tried with variable attribute but the name column always remains there. Please suggest some solution

[Dr Atul G- LNG]

Hi @DP_3105_2 

This is by design — the name appears first, followed by the email ID. Is there a specific reason you want to change it? Also, when you search, the system checks both fields simultaneously, so changing the order won’t make any difference.

[Dr Atul G- LNG]

Hi @GlideFather  I said same thing at first instance. 

[GlideFather]

Hi @DP_3105_2,

If you want to simply change the columns order, then go to variable attribute (Last field in the Type specifications tab of your variable) and make it as you need:

ref_ac_columns=name;email

In this case it will be name, then email and you can switch or adjust

However it might get problems when searching for email and not name, in that case, try this: 
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email,ref_ac_columns_search=true

[Ankur Bawiskar]

@DP_3105_2 

it's platform behavior.

On sys_user table the "name" field is Display field so that will be always shown as 1st

You cannot change the position.

If my response helped please mark it correct and close the thread so that it benefits future readers.