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.
Maybe something like LOOKUP(USEREMAIL(),Auditors,Email,Auditor Name)
@Aleksi_Alkio Thank you, works perfectly…
You’re welcome
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |