This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
It would be great if it was possible to FORMAT TEXT (fonts, colors, bold, italics), CELLS (left, right, center alignment, background colors), and BORDERS (bold or dashed lines, colors) within tables. The ability to add extra header lines and/or to FREEZE more cells vertically and horizontally would help, too.
I really like the idea of Airtable, but canโt effectively use it over Excel until it has more functionality.
I agree. I just started using airtable and I canโt believe you canโt CENTER a column! Youโd think how advanced it is, it could do this simple thing.
Evernote is an example of an app that does a great job of formatting text and making it look simple, clean and readable with the basics of rich text formatting.
โฆbut I will reference @Kamille_Parksexcellent reply from December 2018: RDBMSs typically do not support field-based formatting โ itโs almost an oxymoron. Instead, they depend upon the report-writer mechanism โ in Airtableโs instance, typically the Page Designer Block โ to handle presentation.
That said, most RDBMSs also donโt support such presentation-heavy options as gallery and kanban views, where some field-level formatting would be a boon. In addition, if such formatting is essential to being able to understand the resulting view, some workarounds are possible โ if admittedly too much of a PITA for most uses.
I work with several online database / collaboration tools (for clients) in addition to Airtable and they ALL have the ability to store Rich Text in fields (Ninox, Knack, Podio, Fusioo, Bubble).
Given you could argue that AT has the most โmodernโ feeling UI itโs quite surprising that this isnโt supported yet.
Iโm not familiar with any of those โ but I notice none of them show formatted text in their equivalent of a grid view on their splash pages. (On their more presentation-ish layouts, sure, but not in the backend.)
Obviously, it is possible โ Excel has been doing it for years โ but itโs not a design I associate with RDBMSs;. Iโd like to see at least minor enhancements to the grid view โ field-level conditional colors, text alignment, bold and italic โ and embedded RTF or Markdown would appear to be a good way to be able to capitalize on existing libraries, although weโre still probably looking at a rewrite of significant amount of the core application in order to be able to separate data from display. (Even Open/LibreOffice Writer canโt seem to do it correctly โ and theyโve allegedly supported it for ages.) Still, if I had to choose between making grid view prettier and developing a more robust (and mobile-friendly) Page Designer, Iโd go with Page Designer, every time.
One of the problems โ and this is far from specific to Airtable โ is that nowadays, software tends to be written by people who have spent their careers working for software companies, so often UI/UX reflects other or previous products more so than it does front line industry needs. On top of that, the much-needed shift to Agile methodologies has a tendency to shift too far, diminishing the role of product manager as customer advocate to simply than of another constituent when features and functionality are determined or prioritized. In my experience, whatโs gained in faster time-to-market is lost to later rework. (Then, again, I donโt see anyone knocking down my door to beg me
to return to the glamorous, high-stakes world of corporate software development, so what do I know?)
I accept that most of these apps donโt display the rich text in a grid view - one does though, even allowing HTML tables etc to be displayed in a โtableโ cell.
Thatโs not the whole point though. Letโs say I wanted to be able to enter some text which would later be merged into an email - often you would want this formatted - and not allowing rich text if fields is not ideal.
I donโt really mind if the formatted text is only viewable in expanded view (although I do also accept the need for cell formatting in grid views).
Of course this isnโt the most important update required AT - I would probably vote for proper security and a move towards a more form based UI above this.
That would be a case where Iโd think text formatting would be unwanted, as the mail-merge app or routine should handle the formatting. Separation of content and presentation, right? I can see an argument for content formatting โ being able to make currency look like currency, etc. โ more than text formatting in such a caseโฆ
Of course, what one sees as essential depends heavily on oneโs use case (or oneโs clientsโ use case). For instance, while I agree with the need for more hierarchical, conditional, and record- and field-level authorization and access controls, Iโve maybe created a half-dozen form views in the 2+ years Iโve worked with Airtable โ and at least half of those were to troubleshoot user issues; the form UI is next to irrelevant to me. (Admittedly, if it was more flexible and powerful, it would probably become much more important โ but for now, I work around it.)
I sympathize with Airtable in trying to prioritize user needs properly, given their broad user base โ which is one reason you donโt see me beating down anyoneโs door, begging to be allowed to return to the glamorous, high-stakes world of corporate software development. :winking_face:
