My percentage token doesn't match my data

tesscely · ‎Apr 14, 2023

Hello to you all,

I am trying to create an automation where percentage is taken from the data set to be autocomplete in a gmail message.

Unfortunately, whenever I try to put the token in gmail, it doesn't appear as percentage but as the formula (e.g : 75% appears as 0.75).

I have tried everything - changing the field type (number / single text, long text) and even try to do formula but nothing seems to help...

And another thing : I have tried just putting the number and adding manually in the gmail message the sign "%" and now, my data won't appear at all..

If someone as the solution, I will be really grateful !

Thank you

FlywheelConsult · ‎Apr 14, 2023

As far as I know, you need to use a script to convert the decimal to a percentage prior to inserting it into your email. To do that, you would add a script action step prior to the send email action. Here's the script you would need to use:

function convertDecimalToPercentage(decimal) {
  const percentage = decimal * 100;
  const roundedPercentage = Math.round(percentage);
  return `${roundedPercentage}%`;
}

// Access the input record and field names from the automation setup
const inputRecord = input.config();
const decimalFieldValue = inputRecord.decimalField;

// Convert the decimal field value to a percentage
const percentage = convertDecimalToPercentage(decimalFieldValue);

// Set the output variable for the automation
output.set('percentage', percentage);