I have a custom list inside my SharePoint farm 2013, and the custom list contain these 3 main columns:-
- Status. Options= “Closed”,”In Progress”, “Open”, “Invoiced”.
- Close Date.
- Invoiced Date.
now i set the “Status” as required inside my list settings. but for the “Close Date” and “Invoiced Date” i leave them as optional, but i want to enforce this business scenario inside my Edit form:-
- if the user set the status=Closed >> then the user must enter the “Closed Date” field.
- if the user set the status=Invoiced >>then the user must enter the “Invoiced Date” field.
now i tried to force this validation through list validation, but could not achieve it, also i was limited that list validation will only allow to define one error message + the error message will not be shown beside the intended fields..
so my question is; can i using JavaScript/JQuery to force this validation on the fields?