How to enter information such as annotations in ap...

11166 · 06-02-2020 06:20 PM

How to enter information such as annotations in appsheet
Thank you

Steve

There is no supported way to include comments within expressions.

11166

Is there a place where I can input comments?
Thank you

Steve

Some configuration elements have space for a descriptive comment (as below), but not all.

Some app creators have suggested using an IF() or IFS() expression to inject a comment:

IF(
  TRUE,
  desired-value,
  comment
)

For instance, to provide a textual initial value of Maintenance request with a comment:

IF(
  TRUE,
  "Maintenance request",
  "// The default initial value is Maintenance request."
)

Because IF() results must be of the same type, you may have to cast the comment:

IF(
  TRUE,
  41,
  NUMBER("// The default initial value is 14.")
)

If you prefer, the comment can precede the value:

IF(
  FALSE,
  DECIMAL("// The value of Pi."),
  3.14
)

You can produce a blank value with a comment:

IFS(FALSE, "// Blank value")

Here’s what this approach might look like in a more complex expression:

SWITCH(
  [Fruits by Letter],
  "A", ("Apple" & IFS(FALSE, "// A is for Apple!")),
  "B", IF(TRUE, "Banana", "// B is for Banana!"),
  IFS(FALSE, "// No more fruit!!")
)

11166

Thank you, teacher

If the new version can be annotated at the time,
That would be more perfect!

11166

Another please discuss a lot of good methods?
Thank you