Manual override of data validation suggestions

In appsheet, is there a way to ensure users input data manually despite data validation limiting user input to only valid input?

In the picture below, rather than showing both valid options, I'd rather it remains a blank text field allowing users input the wrong or right options.

Screen Shot 2024-07-28 at 4.11.15 PM.png

Thank you.

โ€ƒ

Solved Solved
0 5 166
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5
5 REPLIES 5

Try this:

IN( [_THIS], LIST("911", "119") )

Thanks, but it is the same outcome.

image.jpg

the resultโ€ฆ

image.jpg

What I want is to give the user an option to input both valid and invalid numbers rather than forcing them to pick from the valid options

I have changed data types and tried different things but I havenโ€™t figured it out yet.

Thank you.

โ€ƒ


@Dubams wrote:

What I want is to give the user an option to input both valid and invalid numbers rather than forcing them to pick from the valid options


'it sounds that you are looking for suggested values. 

Configure suggested values for a column - AppSheet Help

 

Thanks. But suggested values allows user input the wrong data without checking for validity. 

Steve's answer below resolves it.

Thank you.

Steve
Platinum 5
Platinum 5
Top Labels in this Space