Feature Request - Comments inside Application Formula/Expression

Dear Product Developers,

I would like to request a simple feature to allow commenting inside Application Formula/Expression please?

For example, in basic language you can use an apostrophe ’ or in C language you can use the / Comment / combination.

I have some complex formulas and expressions in which I sometimes forget why it does certain things, so being able to comment it line by line would be very useful.

Thanks,

Colin.

Status Open
89 27 3,459
27 Comments
Status changed to: Open
Pratyusha
Community Manager
Community Manager
 
MultiTech
Gold 4
Gold 4

Thought of a solution to this:

Create a new formula function

  • NOTE("Note_String_Here")
    • Basically - the system skips over this, completely ignoring it, when inside a formula

For Example:

If(IsNotBlank([Related Internal Non Conformances]), 
	"6. Internal Non Conformance",

NOTE("Need to finalize the criteria for 5"),
	
If(IsNotBlank([Related Voided Issues]), 
	"4. Voided COR",
	
If(AND(
	IsNotBlank([Related Approvals])
	IsNotBlank([Related CORs])
), 
	"3. Submitted COR",
	
If(IsNotBlank([Related Approvals]),
	"2. Planned COR",
	
"1. Pending Approval"
))))

The system would simply skip the NOTE() and continue with evaluating the "next part" of the formula (just like it would normally).

Joseph_Seddik
Gold 4
Gold 4
Charly
Bronze 2
Bronze 2

tres comillas,  podría ser de cada lado lo hemos probado con mi equipo en BS 

WillVerkaik
Silver 1
Silver 1

Inline Code Commenting: While looking at Appsheets as an enterprise solution for teams to leverage as needed, this is a big surprise/negative to not have available.  Even my experience programming on PETs in highschool in the 1970s, it was not only available but recognized as a fundamental to any environment for programming.   Leaving this out speaks to a risk IMO of the technology.  These are considered table stakes and makes me uneasy that upgrading to solve this is deemed 'tricky'. 

aucforum
Bronze 3
Bronze 3

I am wondering how this might have been progressing please?

Akarumey
Bronze 3
Bronze 3

It would be great to have a possibility to write comments in formulas!

jaichith
Silver 4
Silver 4

ANY PROGESS WITH THIS REQUESTED FEATURE ?

spotlightcanada
Bronze 3
Bronze 3

VSCode is open source, and clearly the editor embedded into AppScript.  Just use that as your expression editor and you can add comments at the same time! 🙂

wabrian
Staff

We are considering this feature for development, thank you all for highlighting its importance and usefulness

PhilippSeidel
Bronze 4
Bronze 4

+1

mikeyhaps
Bronze 1
Bronze 1

This would be amazing. +1 please.