A way to tag our columns? Some databases have SO MANY

Problem


Many of my largest databases have an obscene amount of columns, and it can sometimes be kind of a pain to sort through them and find the ones I need.

Workarounds


Prefixes and Suffixes

Previously I used prefixes (d_Data, fx_Header1, etc.), but this made it harder to reference, since

  • I’d have to remember the prefix

  • I could no longer quickly reference the column with its true name (so I could no longer start typing @Hea… to autocomplete fx_Header1)

  • They influence sorting in the Columns list.

  • It looks really ugly in the Table view!

image

Suffixes seem to be the better way to go, since they get tacked onto the end. But they still show up in various views, like Table and Card.

Emoji

Lately I’ve been resorting to adding emojis to my columns just so I can visually tell what their purpose is: :artist_palette: for decorative elements, :1234: for calculated values, :gear: for user settings, :link: for relations, etc.

It helps quickly visually sort through the noise, but it’s still not ideal:

  • takes longer to search with in the column Search pane

  • same issues as above if used as prefix

  • still shows up on Table view!

Proposed Solution


Would we be able to give “tags” to our columns that are invisible in standard views, but show up in the Column list?

Something like this:

It’d also be great if we could have a way to filter or sort by these tags.

Is the Column Description not suitable for your needs?

The column description is and user facing feature. OP points to a way to organize (tag/group) columns while working inside the settings panel which it would be a quite easy feature to bring to life…

Thanks for clarifying.

Perhaps displaying the column description as a tooltip in the setting panel could resolve the issue.

You also can’t filter or sort by the Column Description. I want to be able to search for “Relations” to show only my Relations columns.