Fixed Value column validation will check that a column contains the values that you have provided.
For example, you can provide the values 1, 10, and 20 and check that a
varchar column contains these numbers.
Select Fixed Value from the ‘Validation Type’ dropdown and the column you want to check for fixed values.
To add fixed value options, provide a value to the Fixed Value Options field and then click Add or press enter on your keyboard.
You can add multiple fixed values.
You can delete a fixed value using the x on its right.
Once you have added fixed values, click Ok at the top right to add this column validation.
Please remember to save this rule from the right-hand slideout if you do not run this rule to save any column validation checks you have just added.