How to populate users email when user name reference field is selected

Bruler1230 · ‎06-14-2019

Hello,

I am looking for an easy way to autopopulate a users email whenever the user name is selected from a reference field (sys_user table). Is there an easy way to do this? Any suggestions are appreciated.

Thanks

Alikutty A · ‎06-14-2019

Oh, This only works on table based forms, not on the catalog form. For catalog, you would need to write a on Change client script and populate the email using a Glide Ajax call to server side.

View solution in original post

Alikutty A · ‎06-14-2019

Hi,

You could add the dotwalk the email address from the User field on your form layout. For this you should configure -> Form Layout and add the User Field.Email field to your layout.

This would gets its done without any scripting.

Thanks!

Bruler1230 · ‎06-14-2019

This would automatically update the email variable field whenever a user name is selected in the user name reference field?

Thanks

Bruler1230 · ‎06-14-2019

And this needs to happen on the form when the user is submitting.

Alikutty A · ‎06-14-2019

When you select a user on the form, the email address would be auto populated on the new field and this would be read-only. Does it make a difference whether it should be on submit or when a user is selected?