Unanswered SharePoint Forms library validation doesn't work with data from InfoPath form

  • Thursday, February 23, 2012 1:57 PM
     
     

    I have Library Validation set on the Forms Library to not accept an entry when one column is blank.  Under Library Settings, Validation Settings I have the following:=NOT(ISBLANK([Date Submitted]))

    The DateSubmitted field comes from an Infopath form.   Despite the Validation Settings, users can save a new form item to the library even though the DateSubmiited field is blank.

    I don't want a user saving back to the Forms library until they use the Submit function, which among other things sets the value of DateSubmitted.  

    It seems that the Library Validation is not looking at a column that comes from Infopath.

    Thanks

All Replies

  • Tuesday, March 06, 2012 9:04 PM
     
     
    You should perform your validation in the IP form.

    /bac

  • Thursday, March 15, 2012 6:24 PM
     
     

    How do I prevent the form being saved back to the library with IP validation?  The user may want to save the form (local file system) to work on it later, I just don't want it added to the forms library until they have "Submitted" it.

  • Thursday, March 15, 2012 6:58 PM
     
     

    If the validation is only enforced after a specific point in the edit process, I suggest you use a validation rule on the field that can be enforced when the status (a new field) of the form is set to "Ready for review" (or something like that).



    /bac