Formula Markdown Formatting

Love the long text field rich text options. Can we extend markdown to formulas as well?


The usage could extend way beyond this, but my use cases are summary fields using rollups and formulas. Right now it looks like this:

But as ‘Satuses’ scales to track more complicated lists, I’d like it to look more like:

001: Modeling (someone’s name)
002: Modeling (someone’s name)

003: Modeling (someone’s name)
004: Modeling (someone’s name)

The bold formatting really makes a difference from a readability standpoint. Monospace or tab characters \t would also be lovely to ensure consistent formatting.


You actually can do this already, just not directly.

Have your formula field generate the text in markdown syntax, and then use Airtable’s API to copy and paste the contents of the formula field into a long text field with rich text enabled. Provided that the API does the copy-paste action, the long text field will parse the syntax and display it as formatted markdown text.

The simplest way to do this is to just use Airtable’s built-in automations, which use the API to perform actions. Set up an automation trigger that detects changes in your formula field and then have the automation copy the contents into the rich text field. But you can also do the same thing through the scripting app, with a third-party service like Zapier, Integromat, or Miniextensions, or through some software you make yourself.

1 Like