In my app I would like the name of the person...

[Nick_Parsons]

In my app I would like the name of the person logged in to appear whenever they fill a new form.

Currently, the column Auditor ID is selected from a dropdown.

I have tried setting the initial value to =useremail() and this works well. However, I need to display the value from a different column (Auditor Name) again, based on the email used to login?

Appreciate any help.

[Aleksi_Alkio]

Maybe something like LOOKUP(USEREMAIL(),Auditors,Email,Auditor Name)

[Nick_Parsons]

@Aleksi_Alkio Thank you, works perfectly…

[Aleksi_Alkio]

You’re welcome