WORKAROUND FOR AUTOMATION EMAIL TO RECEIVE SEPARATELY AND NOT BUNDLED IN ONE E

shaunnelei

Hi anyone here have a work around or formula in my case i created a project where in Effectivity date reach it sends email notifications i also created a helper column for subject to have a unique fields and not bundled in one email but in this case if the same effectivity date different details it was placed in one email trail i tried some sort of work arounds but still it shows like this

Email notifications in same email trail bundled in one email the subject shows 2 entries or how many effectivity dates tied up

It should be like this if no the same effectivity date :

This is my automation

formula for the helper column for subject :

="Final Reminder: CRR Request " + "|" + [CRR Reference number]@row + "|" + [Client Name]@row + [NEW CLIENT]@row + "|" + " Effectivity Date: " + [CRR Effectivity Date]@row

someone can help me any work around on this please thank you

best regards,

Annie :)

Georgie

Hi @shaunnelei,

Thanks for providing the screenshots. I see that your workflow is time-based and uses a placeholder in the subject line. Take a look here for information about placeholder behaviour within time-based alerts: Customize your alerts and requests. 

To summarise the behaviour, if multiple rows trigger a time-based workflow, all rows will be grouped into one email notification and the placeholder in the Subject will be replaced with a default subject. The email body, however, contains one custom message for each row including any placeholders used. 

So, you could edit your workflow to use placeholders within the email body so that when multiple rows trigger the workflow, the single email notification shows the information for each row.

Alternatively, change-based workflows behave differently - they generate separate notifications if six or fewer rows are triggered simultaneously. The system removes the custom subject and body if seven or more rows are triggered simultaneously. Note that if the “Message only” option is selected, any simultaneously triggered rows are combined into a single notification. Therefore, another solution could be to change your workflow to a change-based trigger, such as “When rows are changed”, and have the message include links to the sheet and fields.

I also found a similar idea post here: Automation to send separate notifications per row when a date is reached. Please add your vote to this idea if it matches your request. You’ll then receive updates when the status of the idea changes! 

Hope that helps!

Georgie