InfoPath Dev

My form has a repeating table with 4 columns , column1 has textbox value , column2 has dropdownlist , column3 and column4 has datepicker control

Dropdownlist is loaded from sharepoint library list(secondary data source)

(note: data filter doesnot work in browser enabled form)

When user enters data using repeating table

like

first row

1. Name1  2. dropdownvalue1 3 .1/1/2008 4. 1/1/2008

second row

2. Name1  2. dropdownvalue1 3 .1/1/2009 4. 1/1/2009

I should get a error message stating dat textbox value has repeating value or dropdownlist has repeating value and user should not be allowed to save the form.My form is browser enabled one I need this to be solved without any code

Thanks

Yoga

Hi,

You can avoid the duplicate values by putting the following expressions as data validation.

count(/my:myFields/my:group1/my:group2[my:field2 != ""]) > 1 and (. = ../preceding-sibling::my:group2/my:field2 or . = ../following-sibling::my:group2/my:field2)

and add the screen tip to say the user as there are duplicate values.

Here /my:myFields/my:group1/my:group2 -> repeating group xpath

My:field2 -> drop down list node name

The same will be applied to the text box field.

Thanx a  lot! Your solution worked .

Hi,

Once verify that ‘Always' option is selected or not in the drop down list properties. (Drop down properties -> Browser forms -> Always)

Thanks a for your reply. It worked