Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

New: Progress bars for percent fields

cancel
Showing results for 
Search instead for 
Did you mean: 
Ayesha_Bose
Airtable Employee
Airtable Employee

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.

Ayesha_Bose_0-1686084899936.png

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.

Ayesha_Bose_1-1686084899937.png

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.

Ayesha_Bose_2-1686084899938.pngAyesha_Bose_3-1686084899938.png

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.

17 Comments
kuovonne
18 - Pluto
18 - Pluto

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.

kuovonne_0-1686154914558.png

 

Ayesha_Bose
Airtable Employee
Airtable Employee

@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
7 - App Architect
7 - App Architect

Nice. Thank you.

Kostya_S
5 - Automation Enthusiast
5 - Automation Enthusiast

It is a very good feature.

CReece
4 - Data Explorer
4 - Data Explorer

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

loewe
5 - Automation Enthusiast
5 - Automation Enthusiast

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

CleanShot 2023-10-23 at 15.26.58.jpg

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

CleanShot 2023-10-23 at 15.33.33.jpg CleanShot 2023-10-23 at 15.29.16.jpg CleanShot 2023-10-23 at 15.28.33.jpg CleanShot 2023-10-23 at 15.30.46.jpg

Any suggestions?

Thanks

JBJ
6 - Interface Innovator
6 - Interface Innovator

This is a nice little feature! It make my Analytics tables slightly more visual. Good job, guys.