Help

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

Comments in Formulas

cancel
Showing results for 
Search instead for 
Did you mean: 
Paul_Warren
8 - Airtable Astronomer
8 - Airtable Astronomer

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

3 Comments
Pierre-Yves_Gad
4 - Data Explorer
4 - Data Explorer

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…

MFAB
6 - Interface Innovator
6 - Interface Innovator
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:

alexagora
6 - Interface Innovator
6 - Interface Innovator

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.