Colored or Highlighted Fields

[Tom_Marino]

Hey folks, thanks for a great product.

Simple request: Can you please incorporate the ability to create colored and/or highlighted fields? I’d like to call out certain rows within sheets. With the inferior, last generation sheets programs (shameless sucking up) I’d always used colors for this purpose. I realize I could use a column for this, but its a waste of a column in my mind, especially if you are trying to avoid scrolling left to right.

Thanks for consideration.

[Cindee_Nielsen]

What you described is how I am currently using colors to sort into groups. It would be helpful to be able to use colors to tag data independent of creating a column, even just to temporarily highlight something. I’m excited that this option is currently in beta; hopefully it will become fully functional soon.

[Erica_Marx]

Yes, colors please! For the entire column of data. For example, I have a selection of fields that are synced with mailchimp fields. I want to see them easily.

[Thu_Anh_Nguyen]

Hi Andy, Could you please advise where should I write your suggested code for colouring?
Thanks in advance
Thu Anh

[Andy_Lin1]

The example I gave was only meant as a demonstration of what is possible. The bit of CSS at the beginning will only serve to highlight formula and lookup fields. If that’s what you’re looking for, then what you need to do is install a browser extension that allows you to insert your own CSS into websites, like Stylus, and then create a new style that applies your base and paste the CSS in.
Unfortunately I don’t know of a good tutorial for something like Stylus, but this is their website, and the first page has a link to a video that shows the basics of creating your own style.:
https://add0n.com/stylus.html

[Thu_Anh_Nguyen]

Hi Andy,

I was able to install Stylus and cope the CSS you suggested but nothing change on my airtable base. The screen of my work as below. It would be very helpful if you could have a look and advise me what wrong did I do.

Billion thanks

Thu Anh

[Andy_Lin1]

Hmm, it looks like the quotation marks might be the culprit (the forum automatically converts double quotes to “smart quotes”).
div.cell[data-columntype~="lookup"]{ background-color: red; }
div.cell[data-columntype~="formula"] { background-color: red; }

As for the last entry, the column id is usually a string of 17 alphanumeric characters and corresponds to a particular field (you’ll find this by examining the page source), while the column index is a number that corresponds to the field order in the current view. So you might want to try:

div.cell[data-columnid="blahblahblahblah1"] { background-color: ivory; }
or
div.cell[data-columnindex="1"] { background-color: ivory; }

[Katherine_Duh]

Hey everyone! Today we just released record coloring, which is a Pro plan feature that lets you set colors for records based on filter-like conditions. It works on calendar, grid, kanban, and gallery views—for calendar, the whole card receives a color; for grid, kanban, and gallery, the value in the primary field gets a color flag. Read more about it here!

[Andre_Zijlstra]

@Katherine_Duh personally I would love to see the option of having the choice to set a background color in a column. For example when you present figures and you like to distinguish $ colomns from % columns.
The Single text or Multiple text select would be a stap in that direction, but the colors are gone when you look up this data in another table.

[Jacques_Letesso]

I totally agree with @Andre_Zijlstra here. We should be able to set the background color of a cell base on it’s value.

I use AirTable for financial projection and there is no way for me right to underline irregularities through color coding.

This is an absolute must for a tool like AirTable.

The record coloring feature feels like a half-way good solution.

Cheers,

J.

[Jacques_Letesso]

This is what I do right now with Stylus (very hacky by the way).