We have a form library named "HR Annual Review". In the InfoPath form we have two buttons "Save" and "Submit". User is allowed to Save multiple times and only once using Submit button. The file name of form library "HR Annual Review" will be stored in the format <username>+<mm>+<dd>+<yy>.xml. Say for example, an user named Mike Walt submitted a form then the file name will be as MikeWalt012314.xml. If the same user (Mike Walt) submits the form and tries to open the form for subsequent edit, then we need to show a view which has an error info saying The Appraisal is already submitted for the current appraisal cycle.
Solution we tried:
To achieve the above requirement, we tried using InfoPath Form Load and add a rule to check whether the combination of current user name and the year already exists in the filename column of the form library. But the rule we applied is not checking all the rows in the form library. The rule is always checking the first row of the form library.
What we need:
We need the validation using InfoPath rule or some other way/solution to check whether the combination of current login username and current year file already exists in the form library.
Thanks in ad