🆕 Dynamic colors for number fields - Now in the New Record Experience, Forms, and Mobile


Now you can make your numbers even more noticeable by adding colors. It works in number fields and is visible in all views.

There are two options: assign a fixed color that always displays on the field value, or set dynamic colors based on value thresholds. Dynamic colors update automatically as values change. You can apply multiple rules, and rules at the top of the list override rules lower on the list. This makes it simple to set up even complex and varied color configurations.

Both options are now available on the Premium plan across the new record experience, Tape Forms, and the mobile app when creating and editing records.

:books: How to set it up

1.) Create a number field in the new record experience (Details here ➔)
2.) Open a record in a database app
3.) Open the ⋮⋮ menu in the left margin when you hover over a number field
4.) Select Color or Dynamic color
5.) Dynamic color: add a rule, choose a threshold and a color
6.) Add more rules as needed

:bulb: Examples

Negative values turn red
Add one rule: if value < 0, show the value in red
Useful for balances or any field where a negative number signals a problem.

Traffic light for inventory
· value > 10 = green
· value > 3 = orange
· value ≤ 3 = red

Budget tracking
· value > 100% = red
· value 95–99.99% = orange
· value < 95% = green


A lot of this was already possible with Tape’s calculation field. Now users get direct visual feedback on the number field itself, updating live as you type. Check out the full release post for the Number Field ➔

7 Likes

Hi all,
This is very nice but what I was expecting when I first read “dynamic” is a bit different. I expected to be able to set these color changing values “dynamically” depending on the value of another field/average of a view/calculation.

This would be very useful since we usually don’t know the precise values to compare with the actual number. For example, if we have a field where we store an average (that changes when any record changes) it would be very useful to be able to have a number field in the record where we could compare with the average and set it in red if below or green if above (for example) the reference field (average).

I can easily see how this has a ton of use cases: pricing vs average to see opportunities at a glance, performance against metrics, deviations, etc.

This would be very useful against dynamic metrics.

Thanks.
Best,
R.J.