Skip to main content
Solved

How to maintain % format of formula field in automation

  • August 23, 2024
  • 3 replies
  • 38 views
Cole_Wedemeier
Forum|alt.badge.img+13

Hello!

I have a formula field set to format as a percent in the table. That field is then part of a linked record lookup field in a table that will trigger automation to send emails. I want to share that percentage in the email. However, when I use the lookup field in the body of the email, it only allows me to include the number as a decimal.  Is there a way to get this to show the percentage?

The original formula field formatted as a percent:

The lookup field settings:

The automation's email token:

The result in the email:

Thanks in advance for any help you can provide!



 

Best answer by TheTimeSavingCo

If you do not find any better solution, I’d suggest having an additional field on your table called something like “Formatted %”, where you just multiply the “Reff difference..”  value *100. Then on the body of the email you reference this new field, and you include “%” next to it. Would that help?


@Mike_AutomaticN's suggestion works perfectly.  I'd also suggest throwing in a ROUND() to deal with any floating point weirdness as discussed here



ROUND(Percentage * 100, 2) & "%"

 

3 replies

Mike_AutomaticN
Forum|alt.badge.img+28

If you do not find any better solution, I’d suggest having an additional field on your table called something like “Formatted %”, where you just multiply the “Reff difference..”  value *100. Then on the body of the email you reference this new field, and you include “%” next to it. Would that help?

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6457 replies
  • Answer
  • August 24, 2024

If you do not find any better solution, I’d suggest having an additional field on your table called something like “Formatted %”, where you just multiply the “Reff difference..”  value *100. Then on the body of the email you reference this new field, and you include “%” next to it. Would that help?


@Mike_AutomaticN's suggestion works perfectly.  I'd also suggest throwing in a ROUND() to deal with any floating point weirdness as discussed here



ROUND(Percentage * 100, 2) & "%"

 

Adam, Airtable Consultant - thetimesaving.company
Cole_Wedemeier
Forum|alt.badge.img+13
  • Cole_Wedemeier
  • Author
  • Inspiring
  • 36 replies
  • August 24, 2024

@Mike_AutomaticN's suggestion works perfectly.  I'd also suggest throwing in a ROUND() to deal with any floating point weirdness as discussed here



ROUND(Percentage * 100, 2) & "%"

 


Sometimes, we do these things so often that we over complicate what's right in front of us. Thank you both, @Mike_AutomaticN  + @TheTimeSavingCo !


Terms & ConditionsAccessibility statement