Hello Team,
Currently I have an automation set up to get notifications on the task status (when task is delayed) based on timeline, but i need the notification to be sent only when the “IF condition” in the automation is “true”. Currently the notifiations are being sent irrespective of the condition being “True” or “False”.
Here is the link to the CodaDoc: https://coda.io/d/_d426tEFddV0/121257-Timeline_suFnjzct
Hi Vinay,
The condition on IF should return True or False, the way you have set it up returns one or several objects from the table.
Try adding .count()>0 at the end.
On the other hand, I have the feeling you are trying to send a notification to each PM if they’re task is delayed. In order to achieve this you have to let the IF empty, filter() the tasks that are delayed in the THEN part and forEach() item notify() the current PM. I’m not in the computer and I’m not sure of the notify parameters, but it should be something like this. [Production Planning]. Filter(Status="Delayed").forEach(Notify(currentValue.PM, Format("Your task {1} is delayed", CurrentValue.Feature)))
@Pablo_DV thanks for the feedback. Also is there a way i can set the automation rule so that the notofications are sent only when the ‘If condition’ returns as ‘True’'.
What I’m want to from this automation is that I need to get the notofication only when the status is ‘Delayed’, as of now I’m getting notifications even if the task status is ‘On track’.You can see in the attached image the notification i got even when there is not task delay.
I need the notification to be sent out only to me and not to the PM’s.
@Pablo_DV adding “.count()>0” has solved the query. Thank you for the helping me out.
The automation did not proceed to the next step when the ‘If condition’ returned as ‘false’.
It’s often useful to have a toggle or checkbox column on the table that applies the filter logic for the automation.
Eg Should send notification
This way you can see if the logic is working correctly and just use this column in the if part of the automation
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
