3

Hi all I have a choice field in a list which has data as below

Select
UK
USA
France 

Select is just a value I place there to show users so that they have to select an item from the list.

How do I validate a users so that they don't save without selecting either uk,usa or france .

I am not using a infopath.

4
  • 1
    You can add column validation that choice column value can not be 'Select'. This will help ! Feb 1, 2017 at 12:38
  • how will i add it ? can you show me sample formula ? . is it something to be done in javascript ?
    – Rinu
    Feb 1, 2017 at 12:57
  • Its out the box part. You don't need javascript. Follow steps in answer Feb 1, 2017 at 13:06
  • Do you want a JavaScript code for it? Feb 1, 2017 at 19:29

1 Answer 1

3

You can go to edit choice column for which you need to have validation.Go to Column validation Add below formula

=ChoiceColumnName<>"Select"

Here 'ChoiceColumnName' is name of your column and 'Select' is you value which you don't want user to save. Add your custom message and save.

Hope this helps !!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.