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

(Nick Parsons) #1

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) #2

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

(Nick Parsons) #3

@Aleksi_Alkio Thank you, works perfectly…

(Aleksi Alkio) #4

You’re welcome