Template
Switch Expressions
How to use the SWITCH expression
Industry:
n/a
This app shows how to use the SWITCH expression. The SWITCH expression is useful when you want a formula to produce a different result depending on the value of some other column. Try changing the Number value in the form and see the Message field change in response.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
The Message column is a virtual column with the following formula:
SWITCH([Number],
1, "One",
2, "Two",
3, "Three",
4, "Four",
5, "Five",
"I can only count one to five"
)
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...