1

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.

3

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

1

It's not possible by default. But a small Javascript will do the trick...

addDefaultValues = function() {
    $("select[title$='Required Field']").each(function(){
        $(this).prepend('<option value="">(none)</option>');
    });
}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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