Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Affordance to Organize Fields

cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_Kennedy1
6 - Interface Innovator
6 - Interface Innovator

Hunting for Fields is my #1 time waster in Airtable. I spend lots of time scrolling horizontally through column headings, or vertically through the Fields Pane. I have 5x more fields than I do Views in most Tables and I interact with them (i.e. need to find them) more often too.

Why not add the “Sections” functionality for Fields, like the one that Views have?

18 Comments
ScottWorld
18 - Pluto
18 - Pluto

Yeah, we need better filtering/searching of fields, especially the ability to filter/search/sort by field type.

The only quicker way that I’ve found to search through fields is to expand a record, and then use your browser’s native “find” function (i.e. command-F on Mac) to search for field names.

But overall, a major overhaul is needed here. Since Airtable employees don’t read our messages here, please be sure to send your requests to support@airtable.com.

Bill_French
17 - Neptune
17 - Neptune

Music to my ears! And by music, I mean like this, the most awful music ever.

This is a huge issue and I have often thought someone needs to build a command-line interface in a custom app that would allow things like this given the current table in focus:

  1. show columns like account * (* is wildcard, case insensitive)
  2. show columns with values > 20
  3. show columns that contain dates
  4. show columns that are empty
  5. show columns that have dependencies
  6. save as
  7. clear

Type the command; the grid assumes the new desired render.

kuovonne
18 - Pluto
18 - Pluto

Too bad custom apps cannot create, modify, or delete views. It would be really nice if they could. If and when custom apps gain these abilities, I will want to create such an app.

On the other hand, why should such a tool be a command-line interface? Command line interfaces require users to recall the commands they want; point-and-click interfaces only require users to recognize the commands they want. That makes them much easier to use.

Bill_French
17 - Neptune
17 - Neptune

It’s a good question. Speed is the short answer. Why are Slack and Coda so inclined to integrated CLIs? Speed. Simplicity. Productivity. These tool designers know that features like this are typically attractive to power users and power users are very comfortable with command lines and less thrilled with pointing and clicking.

This is untrue. AI is both practical and performant; it allows humans to ask for the same thing in a variety of ways with great precision.

I predict there is an untapped market of users who would love a CLI that allows them to locate information, change views, and access data more quickly.

Matt_Kennedy1
6 - Interface Innovator
6 - Interface Innovator

Very cool idea. Sort of like Filter Rules, but for Columns instead of Records?

Bill_French
17 - Neptune
17 - Neptune

Yep. If you think of a pivot table on a spreadsheet with 500 fields, now you have 500 rows and no human wants to look through that much crap. Unfortunately, Airtable (and many other tools) fail to understand that the definition of data and meta-data is too rigid. You need to treat all data - even field names - as first-class searchable citizens.

Matt_Kennedy1
6 - Interface Innovator
6 - Interface Innovator

Haven’t tried that, but good suggestion.

I didn’t easily find a lot of Forum discussion about this topic, so created this new one. Maybe its a matter of the words I am using to describe the need. I like ‘filter/search/sort’ - that’s probably both more specific and more encompassing than how I described it.

Matt_Kennedy1
6 - Interface Innovator
6 - Interface Innovator

There’s something interesting about the notion of creating views programmatically, especially with ML predictions: here’s the data you’re looking for and some fields that you’ll probably want to use next.

Bill_French
17 - Neptune
17 - Neptune

You get it. Smart observation.

kuovonne
18 - Pluto
18 - Pluto

While I agree that a CLI can be faster for someone who is proficient with it. It takes time to become proficient with the grammar and vocabulary of a CLI. I think that creating/changing views isn’t needed often enough to make it worthwhile for users to learn a cli.

I do not understand why you say that this is untrue. To use a CLI, you must recall and type the command you want. If the CLI grammar and vocabulary is similar enough to another language (such as English) the learning curve is easier, but the user still has to recall and type the command. However, with a point-and-click interface, the user only needs to recognize the desired commands.

People’s expressive language skills tend to be smaller than their receptive language.