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
Solved! Go to Solution.
Try this:
IN(
[Team].[name],
SELECT(
Users[teamName],
([email] = USEREMAIL())
)
)
โshowifโ is not applicable in this situation. You should be looking at Slices or Security Filters
Iโm trying to create a Slice using the row filter condition but I donโt find the expression that do what I want, Can you help me finding it ?
I tried AND(CONTAINS(Users[Email], USEREMAIL()), CONTAINS(Users[Nom_Equipe], [Nom_Equipe]))
But all those statements are true hahaโฆ I miss something but I donโt know what
Also I have another table called animals and another one called group of animals, those animals have this relation with team
Users 1----N Team 1 ----- N group of Animals 1 ------ N animals
My users can add Animals in their team and in their group of animals contained inside the team but I have a problem, When they edit the animal to change things, they can change the attribute group of animal of the animal, so they can by this way add animals in groups of other team and they donโt have the right to but I donโt know how to counter that ?
Please help me.
Thanks
Try this:
IN(
[Team].[name],
SELECT(
Users[teamName],
([email] = USEREMAIL())
)
)
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |