Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Percent field is appending 0.0% to the value I try to save

Solved
Jump to Solution
391 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everyone,

I’m having an issue that when I save an integer to a percent field, it appends 0.0% to the amount. Let’s say the value is 25 it’ll save as 250.0% anyone has an idea on why this is happening?

And also on the API docs, the percent field is the only one that displays no info.

I have attached screenshots of this.

Screen Shot 2020-06-24 at 5.00.04 PM Screen Shot 2020-06-24 at 5.00.40 PM

1 Solution

Accepted Solutions

This article may be of some help. Specifically:

The percent field type is a field type designed to hold numerical values formatted as percents. The values in a percent field are all represented as fractions of 100 with the percent sign; e.g. the number .75 in a percent field is represented as 75%.

It’s definitely unintended for the field type & description to be missing from the API docs though – thanks for flagging!

See Solution in Thread

2 Replies 2

This article may be of some help. Specifically:

The percent field type is a field type designed to hold numerical values formatted as percents. The values in a percent field are all represented as fractions of 100 with the percent sign; e.g. the number .75 in a percent field is represented as 75%.

It’s definitely unintended for the field type & description to be missing from the API docs though – thanks for flagging!

I somehow missed that. I tried to divide the amount by 100 before but I realized that it was not float, so 25/100 would result in 0.

Your response did it for me. I was able to make it work. Thank you for that!