Skip to main content

I have created an automation that sends an email with text and numbers. The numbers are pulled from two dynamic fields. One field is a percentage and the other field is a currency. However, the percentage and currency formats aren’t making it over to the email (sent by Airtable). Looking for input on how to format the numbers into percentage and USD currency. 

Hello ​@rfulda,


Unfortunately, this is one of the most commonly complained about issues with Airtable.

The solution is easy, if a little clunky. Essentially you need to create a text formatted copy of your fields.

For the Currency Field, create a Formula field using the following formula, where the {Amount} field is your Currency Field.

"$" & IF({Amount}, REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( ROUNDDOWN({Amount},0)&"", "(\\d{3})$", ",$1"), "(\\d*)(\\d{3}),", "$1,$2," ), "(\\d{1,3})(\\d{3}),", ",$1,$2," ), "(\\d{1,3}),(\\d{3}),", "$1,$2," ), "^(\\d{1,3})(\\d{3}),", "$1,$2," ), "^,", "" )& "." & LEFT((ROUND({Amount},2)-ROUNDDOWN({Amount},0))*100 & "0", 2) & " ")

You can just use the Find function (CTRL+F in the formula field) to replace the {Amount} with your field name.

Then in your email automation, use this new formula field as the input instead of the {Amount} field.

For the Percentage, this one is a little simpler, do the same as above but use this formula instead, where the {Percent} field is your percentage field.

IF({Percent},
   ROUND({Percent}, 0) & "%",
   BLANK()
)


Then do the same as before, inserting this formula field into your email automation instead.

Hope that helps!

Tyler this is incredible you are a total G. 

​@rfulda,

Happy to help!
If this solved your problem be sure to mark it as the solution.

Terms & Conditions