Solved: Virtual Text column vs. virtual Show column using ... - Page 2

dbaum · 05-21-2022 05:06 PM

The following seem functionally equivalent when the need is for content that is solely for display within a form view and doesn't need to be referenced anywhere else. Is one more performant than the other? Are there other pertinent distinctions to consider?

Virtual column of Text type with expression that yields row-specific text in the App formula property
Virtual column of Show type and Category of Text with expression that yields row-specific text in the Content property

Example of Text column

Example of Show column using category Text

Steve

A column of type Show category Text is a LongText value, so it allows line breaks.

The Content expression of a Show column is always live, so it will be recalculated even if no change is made to the row. Compare with a virtual column's App formula expression, which is only live in a form view or when a normal column of the same row is updated.

View solution in original post

Virtual Text column vs. virtual Show column using category Text