Hi I have a question relating to expressions. I have a form whereby the user email entered automatically fills out the next column [Operator]. In the AppSheet App, Auto compute, Formula for column Operator (Name) I have the following formula entered:
IF([User Log In] = “JohnDoe@gmail.com”, “John Doe”, John Doe’’)
What I want to do is add more user emails and different operator names only I don’t know how to write this expression. Just for clarification I would like it to be like this;
IF([User Log In] = “JohnDoe@gmail.com”, “John Doe”, John Doe’’) + IF([User Log In] = “JaneDoe@gmail.com”, “Jane Doe”, Jane Doe’’) + IF([User Log In] = “JohnSmith@gmail.com”, “John Smith”, John Smith’’)
LinkedIn
Twitter
