Solved: Expression I need help this is pretty urgent - Page 2

Lucas_FAUGERON · 06-29-2021 07:48 AM

Hello I have 2 tables :

Team 1 ------ N Users

In team one attribute : Name like “Team a”
In users I have two attributes : Email and TeamName(ref to table team)
I wanna do a show the row in team if
If USEREMAIL() exists in Users.email show the Team in the view team

like this just some sql mixed with appsheet may be more understandful →
SHOW Name
FROM team, users
where Users.email = USEREMAIL()
and Team.name = Users.teamName;
I just really don’t understand how to do it…
If anyone has a solution.
Thanks everyone

Steve

Try this:

IN(
  [Team].[name],
  SELECT(
    Users[teamName],
    ([email] = USEREMAIL())
  )
)

View solution in original post