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.