Hi there, I have a question regarding the use...

(Jonathan Fraser) #1

Hi there, I have a question regarding the user email, I have an app that allows the user to do inspections based on yes and no questions in the app. You need to select who is doing the inspection, I want to know if it is possible for the app to auto select the person doing the report based on the user email and “Inspector email” I have in my sheet. The “Inspector” field inside my “Inspection” sheet does not contain the email, this is in another sheet named “Inspectors” where one of the columns is named “Email”.

Is this possible to do?

I have tried modifying this script but with no success: =OR(IN([UserEmail], {“AdminEmail1”, “AdminEmail2”, “AdminEmail3”}), [Market]=ANY(SELECT(Techs[Market],[UserEmail]=USEREMAIL())))

(Aleksi Alkio) #2

You can read the user with the LOOKUP expression… LOOKUP(USEREMAIL(),Inspectors,Email,Name)