Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

The title pretty well speaks for what I need. I have a lookup column on a list, getting data from a custom existing site column i created.

I need it be null by default so they get an error if they don't choose something, but the column must stay as Required.

share|improve this question

1 Answer 1

Not possible really as such, particularly if you make it Required. But as alternative you should rather add a so called "0 option" and using an CEWP in the page you could use ECMA script to ensure validation using something like a jQuery library.

  1. First we need jQuery JavaScript library and the jQuery Validation Plugin.
  2. 2.Upload the validation plug-in into any library in your SharePoint site.
  3. Next, open the SharePoint Site and edit the list’s NewForm.aspx or EditForm.aspx in SharePoint Designer in Advanced Edit mode and go from there.

Example

share|improve this answer
1  
+1 JavaScript is the easiest way to do this, here is a similar question with a script I wrote a while ago in plain JavaScript –  Kit Menke Apr 23 '13 at 21:09
    
Thanks for sharing Kit, got my +1 –  C. Marius - MVP Apr 23 '13 at 21:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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