none
SharePoint Online Validation Fields

    Question

  • I have two fields in a SharePoint Online List and one must be filled out before you are allowed to enter the other list. 

    1st column, a person or group field called 'Approver' 

    2nd Column, a drop-down field called 'Send for Review'

    Is there a way to ensure the Approver name is selected or entered before the Send for Review column allows users to select what type of approval they require? 

    Suggestions will be really appreciated. 

    Thanks in advance, 

    ASLR12

    jeudi 17 mai 2018 18:59

Toutes les réponses

  • Hi,

    You can use InfoPath or script form to disable the 'Send for Review' field if the 'Approver' field is empty.

    Method: Using InfoPath form

    1. Customize the list form in InfoPath.

    2. Add a Formatting rule for the 'Send for Review' field.

    3. If the 'Approver' field is blank, disable this control.


    Method : Using Script

    We can use ClientPeoplePicker.OnUserResolvedClientScript method to run the script when the change event occurs for the people picker field.

    More information about client side people picker control:

    http://ranaictiu-technicalblog.blogspot.sg/2014/11/sharepoint-2013-client-side-people.html

     Then, disable the drop down field

    $("select[title='Send for Review']").attr("disabled", true);


    Best Regards,

    Linda Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    vendredi 18 mai 2018 08:46
    Modérateur
  • Hi,

    Is there any update?

    Does this suggestion help you achieve your requirement?

    If you think it is helpful, please mark it as the answer.

    Best regards,

    Linda Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    vendredi 25 mai 2018 09:09
    Modérateur