# E-mail notification **URL:** \ **Category:** Get Help\ **Created:** [January 15, 2024, 6:46pm UTC](https://community.fibery.io/t/e-mail-notification/5692 "2024-01-15T18:46:05Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 15, 2024, 6:46pm UTC](https://community.fibery.io/t/e-mail-notification/5692/1 "2024-01-15T18:46:05Z")
I’m pretty sure this is quite simple but couldn’t find it on the other posts. Sorry if this information is already available and I haven’t found. I’m setting a notification automation that I want to send and e-mail to a specific user that is assigned as the leader of a group. Like this: Joseph is leader of group A Maria is part of group A, and she is on a pause. There is date field indicating when her pause ends. When it’s one week from this date, I want to send an e-mail to group A’s (the group that Maria is part of) leader, Joseph. I have already managed to set the trigger, but I’m having trouble with the itself. I’m assuming it would be a formula on the TO field from the e-mail automation. ![Captura de Tela 2024-01-15 às 15.40.16](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b57e28893f271d0e4c8e15d5cf58cdfc8c3aa639.png) Something that would indicate: e-mail address of the user who is assigned as the leader of the group to which the step 1 user is linked to. Too complicated? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 15, 2024, 7:11pm UTC](https://community.fibery.io/t/e-mail-notification/5692/2 "2024-01-15T19:11:34Z")
If I understand correctly, the automation is in the User db and is being triggered for Maria, right? Can Maria be part of only one team, or multiple? If the former, then I think you need to use `[Step 1 User].Team.Leader.Email` If the latter, then probably this will work: `[Step 1 User].Teams.Join(Leader.Email, ",")` (and all leaders of teams Maria is in will be notified) ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 16, 2024, 12:08am UTC](https://community.fibery.io/t/e-mail-notification/5692/3 "2024-01-16T00:08:14Z")
Hmm it didn’t work: ![Captura de Tela 2024-01-15 às 21.06.57](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/950f68f2a0e059a93146a3a2a896ebddec2eb96d.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 16, 2024, 12:22am UTC](https://community.fibery.io/t/e-mail-notification/5692/4 "2024-01-16T00:22:27Z")
I guess there is more than one leader of a team? (= relation between Circulos and Coordenadora is to-many) Your original post implied that there was only one. ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 16, 2024, 12:39am UTC](https://community.fibery.io/t/e-mail-notification/5692/5 "2024-01-16T00:39:43Z")
Oh yes! Sorry! There can be more than one leader for the team… ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 16, 2024, 7:03am UTC](https://community.fibery.io/t/e-mail-notification/5692/6 "2024-01-16T07:03:42Z")
You’ll need to add an intermediate lookup or formula in your dbs. I would suggest adding a lookup in your User db, which gets the Leaders from all the Teams. Then you can use `[Step 1 User].[Teams Leaders].Join(Email,",")` ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 16, 2024, 12:08pm UTC](https://community.fibery.io/t/e-mail-notification/5692/7 "2024-01-16T12:08:58Z")
Ok! But then when Maria’s pause ends, all the leaders from my organization would receive the e-mail or only the leaders from the teams that Maria is part of? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 16, 2024, 12:15pm UTC](https://community.fibery.io/t/e-mail-notification/5692/8 "2024-01-16T12:15:45Z")
> [@gomocoop](#): > > all the leaders from my organization would receive the e-mail or only the leaders from the teams that Maria is part of? The latter. `Teams Leaders` is the lookup that returns only the leaders of teams Maria is part of. ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 16, 2024, 2:33pm UTC](https://community.fibery.io/t/e-mail-notification/5692/9 "2024-01-16T14:33:46Z")
Yey! It worked!!! =) But now, for some reason that I don’t understand, the filter is not working… ![Captura de Tela 2024-01-16 às 11.30.51](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3cb4cb6886c55701aed0d2ac8685c7bbfdabc9e4.png) ![Captura de Tela 2024-01-16 às 11.32.34](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0e0d95bcc0fe9de273f5aca0c1068364f4ddb449.png) And as far as I know everything is set correctly… ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 16, 2024, 2:36pm UTC](https://community.fibery.io/t/e-mail-notification/5692/10 "2024-01-16T14:36:56Z")
Ok! Found out! There’s one day difference… When I changed the end date of the person to Jan 15th the filter worked… ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 16, 2024, 2:38pm UTC](https://community.fibery.io/t/e-mail-notification/5692/11 "2024-01-16T14:38:41Z")
This might be interesting/useful to know: [https://the.fibery.io/@public/User\_Guide/Guide/Date-Ranges-in-Formulas-42](https://the.fibery.io/@public/User_Guide/Guide/Date-Ranges-in-Formulas-42) ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 16, 2024, 2:41pm UTC](https://community.fibery.io/t/e-mail-notification/5692/12 "2024-01-16T14:41:07Z")
Thank you! Now I have another question but not sure if I should open a different post… Is there a way to set up the e-mail that will be sent? Because is quite plain… ![Captura de Tela 2024-01-16 às 11.39.09](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/91eea22a5def5e633d342b067963a935310457de.png) Can I set it with pics and different font, like the Fibery notification: ![Captura de Tela 2024-01-16 às 11.40.01](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/45d2f424e7968fdfe082df19014df3c8ed887c0e.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 16, 2024, 2:44pm UTC](https://community.fibery.io/t/e-mail-notification/5692/13 "2024-01-16T14:44:41Z")
> [@gomocoop](#): > > Is there a way to set up the e-mail that will be sent? Because is quite plain… You can use markdown to format the email message: [. | Fibery](https://the.fibery.io/@public/User_Guide/Guide/Markdown-Templates-53) ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/23459fbfc23626f9ff27e4eb365ac1a6b6e6caeb.png) ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 16, 2024, 2:56pm UTC](https://community.fibery.io/t/e-mail-notification/5692/14 "2024-01-16T14:56:00Z")
Ohhhh. Thanks! I’m gonna study it. =) ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [January 17, 2024, 2:56pm UTC](https://community.fibery.io/t/e-mail-notification/5692/15 "2024-01-17T14:56:10Z")
Just learned a few things from markdown. \<3 Thank you so much @Chr1sG ! For another automation, I want an email to be sent when a task reaches a date. The trigger is ok. But I wanted the e-mail to be sent to the Team Leader of the Circle from which the task is related to… I thought it would be something like: `[Step 1 Task].[Team].[Team Leader].Join(Email, ",")` but that’s not working… Tasks are related to Circles (many-many) and Circles are related to Users [Team Leader] (many-many). How would I do it? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 17, 2024, 3:31pm UTC](https://community.fibery.io/t/e-mail-notification/5692/16 "2024-01-17T15:31:33Z")
The dot notation in formulas can be used to get field values from single entities, so you can use `Task.Teams` to get the teams for a given task, and you can use `Team.Leaders` to get the leaders for a given team. This can work over multiple levels, provided that the dot is following a single entity, so you could use `Task.Team.Leaders` if a task has only one team. But you can’t use this method to get values from a collection of entities, so `Task.Teams.Leaders` won’t work, since you’re trying to get properties from a collection of things (getting the Leaders from the Team **s** ) However, lookups _can_ work via collection fields, so you can create lookups in your databases to make these ‘indirect’ values available. For example, you could add a lookup to the Task db which gets the Leaders from the Teams. And then this field (called “Teams Leaders”) will be available to use in your automation: `[Step 1 Task].[Teams Leaders]` Note: If you try and use a dot after a collection, the auto-complete will offer suggestions for ‘aggregation’ functions (Sum, Avg, Max, Join, etc.) which work to provide aggregated information on the field properties for the collection. ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [July 10, 2024, 7:23pm UTC](https://community.fibery.io/t/e-mail-notification/5692/17 "2024-07-10T19:23:14Z")
Hello! My rule for sending email was working just fine for the last 6 months… but then out of nowhere it started to fail… did something changed in the system or something like that? I haven’t changed anything on my workspace… I’m using the same formula on my rule: [Step 1 Tarefa].Responsaveis.Join(Email, ", ") And I still have the database Tarefa, the field Responsaveis and the field Email… All good… But it’s been 5 days that it’s not working anymore… Could u help me? Thanks! ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 10, 2024, 9:27pm UTC](https://community.fibery.io/t/e-mail-notification/5692/18 "2024-07-10T21:27:57Z")
Does the activity log for the automation show anything useful? What type of email account is being used for the sending? ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [July 11, 2024, 12:21pm UTC](https://community.fibery.io/t/e-mail-notification/5692/19 "2024-07-11T12:21:15Z")
![Captura de Tela 2024-07-11 às 09.20.13](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/77b3f01946f79a3b67aee001b33fb450b7172515.png) That’s what the activity log says… It’s just a regular email account, from gmail… ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 11, 2024, 12:47pm UTC](https://community.fibery.io/t/e-mail-notification/5692/20 "2024-07-11T12:47:35Z")
What is (are) the formula(s) being used? Maybe, try to find the last time the automation ran successfully and the first time it didn’t, and note the dates. You can look in the workspace activity log to see if there were any schema changes in between those times. [Next page](https://community.fibery.io/t/e-mail-notification/5692.md?page=2)