I am currently trying to make a specific Column mandatory on SharePoint Datasheet View. SharePoint default validation on Column or List Level are NOT an option.

I allready have the Code to check for the right view GUID and so on, but I can't find any hint on how to make a specific Column mandatory in a specific view.

I would be happy if I could insert the JS later on the Masterpage Level, but it would be also okay if it works via js Link.

I have tried for days now but I don't find the right point....

I hope it is understandable what I am trying to do.

1 Answer 1


I think you can go with customizing the particular list in infopath designer, make certain fields based on your requirement conditionally using the infopath rules.... this is very simple to implement than going with the coding approach.

  • Hi thanks for the info! I will have a look at this, but to be onest, I didn't work with infopath designer jet.
    – l.Rebig
    Commented Feb 26, 2020 at 8:42
  • As far as I understand, InfoPath doesn't work with the datasheet/ quickedit view? So sadly, this doesnt help...
    – l.Rebig
    Commented Feb 26, 2020 at 8:58
  • When we are applying conditional rules for mandatory columns, it does not matter in which view we are opening this as this works on the column level :-) try this first in your test server.
    – SP 2022
    Commented Feb 26, 2020 at 9:01
  • Sorry to ask again: But isnt this the same as list item validation? Can I go there and say: If viewGUID = XYZ, Field "myfield" = required? Because I cannot only make a Field required based only on other Field Inputs.
    – l.Rebig
    Commented Feb 26, 2020 at 9:22

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.