Colored or Highlighted Fields


#1

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.


#2

Agreed. Need Colors. For spreedsheets colors are very important !! I second your request !!


#3

Conditional colors please thank you


#4

We’ve gotten a lot of requests for the ability to color/highlight fields and it’s something we’re considering. Here’s an article on how to approximate color-coding, in the meantime.

Related to the above support article, I would say that there are two general reasons for which our users have requested colors (which aren’t really the same request, and thus require different solutions and different approaches from a product standpoint):

  1. Manually color individual cells/rows/columns to “tag” something (e.g. every vegetarian in this list of dinner attendees has a green background)
  2. Conditional formatting to color a certain record given a certain condition (e.g. make it so that every overdue project automatically appears with a red background)

For users who want colors for the first purpose, a colorful single select field may be the best bet, and for users that want colors for the second purpose, a formula field combined with emoji is a good alternative.

How would you all like to use colors in your workflows? Something more manual and freeform, or something like conditional formatting? What specific benefits would it bring you? Would you want to highlight entire fields or records, or just individual cells? If you have any feedback, please let us know!


#5

I use colored fields and text in Excel to denote progress of an order. For example:

Each line in my spreadsheet represents a customer’s order, with the most recent orders added to the bottom. Columns represent stages of design & manufacture. As each part of the design process is completed (ex: the customer approves a design proof), the date it happened is entered into the column. We want to color-code a field based on whether it’s been requested, is in-progress, or has been completed. We can’t use color-coded drop-down options because the content of the field is going to be a unique date.

Also, we submit batches of orders for manufacturing on a weekly basis. The “Dye-Sub Purchase Order Submitted” column (the content is a date) is then colored either light blue or light pink, with each weekly batch alternating colors so they’re very easy to pick out visually. (last week’s batch was pink, this week is blue, next week will be pink, etc.) That’s important, as we deal with entire batches from that point forward, not individual orders.

Basically, we just need the ability to color-code individual cells at will. It seems a very simple feature to incorporate, and strikes me as the type of thing that would have been available in the earliest versions of this software. Honestly, I’m testing other similar pieces of software right now only because I can’t color-code cells in Airtable.

Likewise, we should be able to color text, and have access to really basic formatting options, like boldface. I know this isn’t Excel, but those sorts of things are really, really commonly used by pretty much everyone who uses a spreadsheet for anything beyond calculations. People who use Airtable want it to behave like a spreadsheet.


#6

I would love to have the ability to color different portions of my table (different sections of groups of fields).
For instance, if I have a table within a base, and it has 100 fields, some of those fields may be related to “Spring” programs, some to “Summer” and some to “Fall”. If I could group the fields that belong to different seasons, it would make viewing them on mobile devices much easier. The reason this becomes an issue on mobile, is due to the user not moving thru the table starting at the beginning and moving to the end, in many situations, the user in the field, will use their mobile device, but need to jump around within the table, and the color coding provides a very fast reference for “where” in the table you are currently viewing on that small mobile screen.


#7

I think this would be a very big help in a number of different circumstances, and with the right varied set of options for utilizing it, everyone could be happy. I built a table for tracking warranties and have a couple columns for start/end dates and then a formula field for whether that warranty is active or expired. Because this isn’t a single select column, I can’t color code it to show Active as green and Expired as red; additionally, I had to add a column for this Status info when conditional formatting would allow me to highlight a record already based on criteria in the Coverage Ends column (if passed, red, if not, green).

I know columns can be added with these formulas, but since right now hiding columns only works in the grid view and not the expanded view, this isn’t a huge help. I have quite a few bases filled with hidden columns used for formulas and lookups that then clutter up the expanded view if someone tries to look there. I think this builds on the request to add true hidden columns since the answer to this request is often to create a column with a formula and then hide it.

Just my two cents. :slight_smile: Would love to see something like this someday.


#8

I would love to be able to have a visual distinction on fields where the field is calculated or populated by a method other than data entry. Seeing formula fields in a different font style or color would really be helpful for understanding tables where a small amount of user inputs calculate a large amount of fields. Differentiating between input fields and fields that are auto-generated by calculations would be very useful.


#9

Hello,

I would love to have colours enabled in Calendar view, like maybe having them coloured by type of post or so. Because I use airtable as editorial calendar mainly.

Thanks


#10

Couldn’t agree more; color for the calendar view would be a HUGE add for me. I’m using AirTable for project management, and I am trying to dispatch technicians from it. I would love to be able to color code appointments by which technician was scheduled for it so I could look at the calendar and quickly see whether my “blue” technician was scheduled for anything that day.


#11

I would also really love to have the ability to color whole entries and columns. I love Airtable so far and this is really the only thing missing for me. Thanks so much!!


#12

One thing also in particular is when you have a lookup or linked cell in a table. Since the colors don’t come across. I would like to easily visualize which rows have a particular value in a linked cell (say status of an element i am referencing)

Would be very powerful. Am interested to investigate the IF workflow with lookups?


#13

agree, need colors please


#14

Totally agree, the ability to be able to colorize / highlight certain individual fields I think is essential


#15

Fantastic idea! Even being able to color the text would be helpful.


#16

Heartily concur. I’m using AirTable as an editorial calendar across seven or eight platforms. Despite having a field for platform in the spreadsheet view, the only way to distinguish between platform in the calendar visually is to the image attachment field to upload an icon, which makes the Kanban view unproductive as I can’t show the photo asset for the content.

If we could assign a field in the spreadsheet to dictate the background color of the entry int he calendar field, this would be perfect.


#17

Could you clarify what you mean by not being able to “show the photo asset for the content” in kanban view? (Perhaps you meant calendar view? You can put a cover photo on a kanban card.)

As a workaround to make records more easily visible in the calendar view, you could try appending a conditional emoji to the beginning of the record name in the primary field using some of the techniques laid out in this support article. You could set it up so that (for example) a record which has the value “Twitter” in the platform field will have a :bird: at the beginning of its name.


#18

Hi Katherine,

That was a little unclear. What I meant was if I used the attachment field to upload an icon to identify a social media platform, that became the primary image in the calendar field, as well as the new Gallery and Kanban views, which means I couldn’t show the approved editorial photo/art/graphic for the post.

I’ve constructed a formula to append an emoji to the primary field as per your suggestion. Thank you for the feedback and suggestion.


#19

Hi Just to add my bit: I am using Airtable to assess daily data and attribute a number to the resulting range for the daily data. I want to use say bright red for very negative numbers, through amber for around 0 to very green for very positive numbers. This will give me the ability to create a heat map down a column. Therefore the colour would be dependent upon where the value sits in the range. i.e this would be option 2 in @Katherine_Duh 's description of choices.


#20

1+ to this kind of request