Solved: New Bug Encounterd: Cannot find column

Remco_Edelenbos · 01-21-2020 05:08 AM

Hi,

I dont know why it won’t work…

Remco

Kirk_Masden

This is a Show if constraint for a view called “Test.” So, in this context, [Teamleaders] is incomprehensible. If the table name is “Test” I wonder if the following wouldn’t work:

In(USERMAIL(),Test[Teamleaders])

Here’s part of the explanation from the IN() page:

IN(USEREMAIL(), AppUsers[Email]) answers the question: is the current app user’s email address (USEREMAIl()) found in the list of Email addresses in the AppUsers table (AppUsers[Email])? See also: USEREMAIL().

View solution in original post

Kirk_Masden

This is a Show if constraint for a view called “Test.” So, in this context, [Teamleaders] is incomprehensible. If the table name is “Test” I wonder if the following wouldn’t work:

In(USERMAIL(),Test[Teamleaders])

Here’s part of the explanation from the IN() page:

IN(USEREMAIL(), AppUsers[Email]) answers the question: is the current app user’s email address (USEREMAIl()) found in the list of Email addresses in the AppUsers table (AppUsers[Email])? See also: USEREMAIL().