Referencing the sys_user email address

[Jason Stephens]

How would I create a reference variable that is referencing the email address from the sys_user field?

[fagnerecher]

Hi All,

   I've found this article and tried this script on a catalog item but do not solve my problem completly. 

ref_auto_completer=AJAXTableCompleter,ref_ac_display_value=false,ref_ac_columns=email;

  When a type the fullname I can see the Caller.Email (image 1) but can't search by Caller.Email (image 2). Is that possible? 

[Jim Coyne]

You need the following attribute as well to enable the searching of the additional fields being shown:

ref_ac_columns_search=true

So the entire attribute would be:

ref_auto_completer=AJAXTableCompleter,ref_ac_display_value=false,ref_ac_columns=email,ref_ac_columns_search=true;

[Tony96]

Is it possible to select a user name on a newly created form under a catalog and to auto populate the email address, phone number (the record was updated manually to have the phone number) and address... Thanks in advance for your assistance!