Dear AppSheet Team,
Thank you for everything you do. As a user, I truly enjoy the benefits of this platform, and as a way of continuously showing my appreciation, I actively share ideas—just like everyone else in this community, as you may have noticed.
Today, I bring you an idea, and I hope that it (does not make you burst into laughter). Please understand that I am an architect, not a programmer, and therefore, I am somewhat of an outsider in the world of applications. A world that, had I discovered it earlier, might have made me reconsider studying architecture.
It would be something like a Boolean Enum.
Let’s get to the point.
There are times when we use boolean columns (Y/N) to validate conditions:
If something happens → TRUE
Otherwise → FALSE
Other times, Enum-type columns are necessary, as the number of options to check is greater than two (even more than three if we consider NULL ).
Now, let's assume a list of five elements:
SWITCH(
[Column],
"Case1", "Response1",
"Case2", "Response2",
"Case3", "Response3",
"Case4", "Response4",
"Case5", "Response5",
false
)
Imagine that suddenly we need to rename "CaseN" to "Case n" , "Situation n" , or even change the language. In that case, each Enum option must be manually updated (unless it is a Base Type Ref , but I am specifically referring to Base Type Text ).
My Idea
I thought it would be useful to enable a "Display" option for Enum entries, like a toggle button that, when activated, allows entering a display value.
This would solve expressions using a fixed value (e.g., A, B, C, D, E), while assigning a custom display name for each one.
This separates the internal logic from the visual interface, improving usability and facilitating internationalization.
Well, that's it! Wishing you all a great day.
Best regards!
... View more