May 26, 2022 03:38 AM
Hello,
I am currently setting up prefill formulas and everything seems to be fine except for fields with percentage values, they get prefilled with either 0% or 1 %
Kindly advise how to go about this.
Regards,
Nelly
May 26, 2022 03:56 AM
Welcome to the Airtable community!
There are probably two related issues.
Percents are stored internally as decimals. So one hundred percent is stored internally as 1. Zero percent is stored internally as 0.
The formatting for formula fields that produce numbers often needs to be adjusted. Instead of showing the number as an integer, change the formatting to show as a percent with your desired quantity of decimal places.
If this doesn’t help, can you share some screen captures?
May 26, 2022 04:10 AM
Hi Kuovonne,
Thank you for your response.
Let me share the screenshot to my field config,percentage showing on sample record and percentage showing on a prefiled form
May 26, 2022 05:27 AM
What happens if you try to prefill with 100 times the value?
May 26, 2022 06:00 AM
The field type is in percentage, so there is no room for inputting the formula(y*100) since it’s not a formula type field
May 26, 2022 06:17 AM
How are you generating the prefilled url? If you are using a formula to generate the prefilled url, you can do the multiplication in the formula that generates the prefilled url.
May 26, 2022 06:56 AM
It creates an error in the formula when i try doing that
May 26, 2022 09:08 AM
Instead of writing {GM LOCAN} * 100
, you wrote {GM LOCAN*100}
. Meaning Airtable is looking for a field literally named “GM LOCAN*100” which doesn’t exist. You may also have to put that into parenthesis since you are then converting it to a string with &""
. So it likely should be (
{GM LOCAN} * 100) & ""
May 26, 2022 11:44 PM
Hi @Kamille_Parks ,
This actually worked :slightly_smiling_face: :slightly_smiling_face: .Thanks so so much to you and Kuovonne.