Character Limit on Emailed Notifications

A.J.

We use automation to gather certain field data each morning and send a daily "news" report to internal customers. Recently, we've received a "message truncated due to length" or similar when there were many entries that met the send criterion.

Is there a character limit in the automated emails that come from notifications?

Gia Thinh

Hi A.J,

It seems your email body exceeds 2000 character limit. This leads to "message truncated due to length" warning.

Try to create a helper column "Count" in your sheet to count the characters of all field you want to add in the workflow. Then in the workflow, you will check the condition : If Count < 2000 then send all fields, else send fields in 2 seperate emails.

Hope this works for you.

A.J.

@Gia Thinh , what formula does a character count?

Andrée Starå

Hi @A.J.

I hope you're well and safe!

Try something like this.

=LEN([Primary Column]@row)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

A.J.

Hey @Andrée Starå, How would I have the character count add across multiple columns? I've never used that function before.

Andrée Starå

@A.J.

If the columns are adjacent, it would look something like this.

=LEN(JOIN([Column10]@row:[Column13]@row))

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!