Send notification to member of a team, when a memb...

Sven_Arndt · 09-02-2021 12:34 AM

Hi All

I am trying to get the automation to do the following:

when person A is team A updates their location, then notify all members of team A about it. but from what I can determine, I would need to create a separate automation for each team, whereas having it automatically register you are in team A, notify all members of Team A would be better

Aurelien

Hi @Sven_Arndt

did you have a look to this ?

I suggest you create a bot from suggestion

then adapt the one with “notification” to your use case.
Let us know if you need some help after this

EDIT 1 : minor change

EDIT 2:
I forgot to answer about that:

There are many ways to achieve the same.
Short lead: You may want to use a “Users” table, and a slice based on it, in order to get the list of all recipient from the same team.
Let’s say you have a table “Users” with columns “userID”, “email” and “team”, you may want to use this row filter condition:
[Team]=LOOKUP(USEREMAIL(),“Users”,“email”, “team”)

For reference:

Sven_Arndt

Hi

I got the part about the automation and have that up and running, but the part I was missing was slices part.

this suggests that there is currently no way to have appsheet filter the teams on its own through some formula, but requires a slice everytime a new team is potentially made, I was hoping to skip all the manual interventions and have it intelligently determine if user is in team A, find all members of team A, and notify them.

but the formula [Team]=LOOKUP(USEREMAIL(),“Users”,“email”, “team”), would this still require a slice? sounds smart enough to compare team against the main list in my data table

Aurelien

Hi @Sven_Arndt

About this:

Actually yes, I was suggesting a solution that I think the most efficient, I may be wrong.
As I said, there are various ways to achieve your goal.

Another solution (let’s name it Solution 2) would be to use this expression in the recipient expression:

SELECT(Users[Email],
  [Team]=LOOKUP(USEREMAIL(),“Users”,“email”, “team”)
)

just another way to make it

About that:

Actually no, the row filter condition I mentioned is to adapt the slice to the user team. This is the direct answer to your previous question

Let’s get back to the Solution 1:
This expression:
LOOKUP(USEREMAIL(),“Users”,“email”, “team”) will get the current user team,
and this expression:
[Team]=LOOKUP(USEREMAIL(),“Users”,“email”, “team”)
will change the slice content, in order to get the list of users according to the current user team.

What are the main difference between the two solutions here:
The slice is a kind of a “yet filtered table”, so less calculations needs to be made when it’s time to notify.

I hope I made it clear, let me know if you need further explanation.

Cheers !

Edit : for additional reference:

Sven_Arndt

I kind of realized after writing it, that your solution initially made a table that would adapt to each user.

I will give the second formula a try as this appears to be the simplest solution. thanks for the help. its appreciated.

Send notification to member of a team, when a member of that team does a update