Skip to main content

Comments in Formulas

  • May 4, 2020
  • 3 replies
  • 12 views

Forum|alt.badge.img+18

Can you please add comment functionality in functions? This would be a big help when understanding previous peoples work!!

3 replies

It would be so useful to be able to comment formulas!
For our own sake, in the first place, when we have to create complex formulas, as well as for our collaborators, to give the the chance to understand the reasoning behind a formula’s development…


Forum|alt.badge.img+9
  • Known Participant
  • November 9, 2022
IF({Formula Field}="Recognize Comments", ":clap:", ":expressionless:")
// +1
/* +1 x 2 */

The markdown code block on the community forum recognizes comments but the Airtable Formula Field does not. :expressionless:


Forum|alt.badge.img+4
  • New Participant
  • April 10, 2024

Like Excel, Airtable formulas are functional programming, similar to Scheme. Scheme allows any line to END with a comment, by starting the comment with a ;. E.g.

IF(Expression,                      ;check this first 
  Eval_If_True(Something...)        ;use this formula when true
  ,Eval_If_False(Something else...) ;if false, then look at... 
)

Being able to comment like that would make the field immensely better.