Checking duplicate records in repeating table of Infopath


debugmonitor

While creating infopath form I am facing problem when I want to put validation in repeating section,

Here I have an requirement that validation should fire when same date is repeat again in repeating section, below is the solution I found after long research which may help you too :

 

  • Expession=count(/my:myFields/my:group1/my:group2[my:dtPckr != “”]) > 1 and (. = ../preceding-sibling::my:group2/my:dtPckr or . = ../following-sibling::my:group2/my:dtPckr)
  • For Repeatation Group = my:myFields/my:group1/my:group2
  • For DatePicker = /my:myFields/my:group1/my:group2/my:dtPckr

Here I can achieve this without using single line of code which saves my time too

View original post