Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Percentage Fields no showing correctly in email automations

Topic Labels: Automations
Solved
Jump to Solution
146 2
cancel
Showing results for 
Search instead for 
Did you mean: 

When incorporating a % field into an email to be sent by an automation, it converts into a decimal in the email automation.

1 Solution

Accepted Solutions

To be clear, the conversion happens in the per cent field; the data is a decimal which is rendered as a percentage in the column. The email system is simply rendering exactly that which is in the field unless you tell it to interpret that field differently as @49erAllie demonstrated.

See Solution in Thread

2 Replies 2

Hey John!

I have a workaround that may help you out!

Create a formula field

Your formula is going to be
CONCATENATE(({Percent}*100), “%”)

(replace {Percent} with the actual name of your percentage field)

In english, this formula says
Take this decimal, multiply it by 100, and then create a text string that appends the result of that multiplication with a “%” symbol

You can use this field when creating your automation, and it should correctly format as a percentage in your email

To be clear, the conversion happens in the per cent field; the data is a decimal which is rendered as a percentage in the column. The email system is simply rendering exactly that which is in the field unless you tell it to interpret that field differently as @49erAllie demonstrated.