Invalid Error Messages USUALLY tell the user Why the data is wrong, or suggest a correct input.
This Tip is more fun, than functional.
It could be used to add character to your app, or maybe even in creating a turn-based game (dice role).
SWITCH(RANDBETWEEN(0,9), 0,"You're not even trying. 😢", 1,"You can do better than that.", 2,"Is that your final answer?", 3,"PEBKAC Error ⌨️🙃🪑", 5,"⭕️ I'm sorry, Dave. I'm afraid I can't do that.", 6,"Here we go again! 🤦", 7,"INCORRECT!! ONE TRY REMAINING!!", 8,"Yeah, uh... I don't think that's gonna work.", 9,"1010-BEEP-⚡️-GLRORK-RABLE-RABLE-CHUCHUNK-ZZZZZZZ", "Default Response")
IF the column has any kind of validation or expected format AND the input does not match, one of the values will be randomly selected and displayed.
NOTE: In this example, the Valid_If expression ensures the value is unique.
The value entered is unique, but still failing validation because the TYPE is set to Number, and the input is Text.