New: Progress bars for percent fields

[Ayesha_Bose]

Hello! I’m Ayesha, a Product Manager here at Airtable. We’re so excited to share a small improvement to let you display your percentages as progress bars.

What are progress bars?

For your fields that are formatted as a Percent, you can choose to display the field as a progress bar. You’ll see the progress bar in all the surfaces where you see that field today, across your bases and interfaces. In forms, you’ll still see just a numeric input.

How do you enable progress bars?

Progress bar formatting is a supported option for the following field types:

• Editable fields
  • Percent

• Computed fields with a numeric result (format must be “Percent”)
  • Formula
  • Rollup
  • Lookup (only lookups with 1 number value are shown as a progress bar.)

Enable it with “Display as progress bar” under Formatting.

You can also enable the ability to see the percent values next to the progress bar.

How can you customize the colors?

By default, progress bars are shown in a medium green color. If you’re on a Pro plan or higher, you can customize the color of a progress bar and add in conditional rules. We’ll color the progress bar with the first color that matches.

—

We’re looking forward to hearing what you think, please let us know if you have any questions.

This update is available now. If you aren’t seeing these changes reflected, please try clearing your cache.

[kuovonne]

Thank you for this wonderful new feature. I really like how it is introducing more formatting options to existing field types (versus adding field types). It is a beautiful implementation.

I experimented with using negative values and numbers over 100%.

Negative values appear identical to 0%. I was not able to find a way to make them look different. For example, when looking for a percentage change in a value, I would want to be able to see easily if a value went down versus staying the same. I'm not sure what this should look like and I understand the choice for the current implementation. Just hoping for something interesting if you revisit this feature.

For percents over 100%, the bar is the same fullness as 100% but I was able to use coloring to differentiate between the two. Yay.

For very large percents (over 6+ digits?), the formatting is cut off. This is a super minor quibble. I don't see why anyone would have such a large percent in practice.

The alignment of the numeric percents appear to be centered, instead of left aligned (they way percents are aligned without a progress bar). I'm curious about this design choice.

[Ayesha_Bose]

@Databaser: thanks for flagging this! In List View, we don't show the name of the first field but if you move your progress bar field to the right, you should see the name of the field show up. Let me know if you run into any issues with that. 

[Tobias_LGKR]

Nice. Thank you.

[Kostya_S]

It is a very good feature.

[CReece]

This is a great feature, but would be even more useful on a dashboard than within the table itself.

[loewe]

Hi, that's a really nice feature.

I have an issue with this though, the color formatting seems buggy:
With decimal percentages the conditions are not recognized properly, I have the following conditions on a field

the results unfortunatelyare not correct for values that are near the "breakpoints".

   

Any suggestions?

Thanks