Expression I need help this is pretty urgent

AppSheet AppSheet Q&A
, ,
1

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

2

“showif” is not applicable in this situation. You should be looking at Slices or Security Filters

[Current_User (Slice) - How to conform your app around WHO is using the app](https://community.appsheet.com/t/current-user-slice-how-to-conform-your-app-around-who-is-using-the-app/35639) Tips & Tricks ?

One of the core basic functions, included in just about EVERY app I make, is the ability for the app to know WHO is using the app. If the app knows who’s using it, then I can easily control many different aspects of the app: Add/edit/delete permissions How data should be filtered What views are shown What buttons, or Actions, are visible Which workflows should fire off Which columns should be shown or editable etc. Requirements To accomplish this functionality in your app, you need the follo…

2 Likes
3

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

4

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

5

Lucas_FAUGERON:

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;

Try this:

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