Hello everybody,
I'm trying to write a formula in one of the fields of a repeating table to mark the duplicate rows (the repeating table talks to a SQL table and has a foreign key constraint to another SQL table, not sure if that would matter in addressing the issue).
Below 2 solutions look pretty straightforward, except that I can't figure out the correct XPath. I get count as 0 all the time.
http://social.msdn.microsoft.com/Forums/nl-NL/sharepointcustomizationprevious/thread/b1116104-1cc4-47a3-919a-e68e9b57fc6a
http://www.bizsupportonline.net/infopath2010/find-duplicate-values-repeating-table-infopath-2010.htm
Image of myFields panel here:
http://postimage.org/image/8ai3f93md/
"ScoreCard_Period" is the field that should serve as the ID and "Error_Status" should contain the count (Validator).
Right clicking the "ScoreCard_Period" and copying XPath gives following:
/dfs:myFields/dfs:dataFields/d:EUS_Account_KPI_Configuration/d:EUS_Account_KPI_Data/@ScoreCard_Period
Any help in arriving at the formula that needs to be copied to "Error_Status" ("Validator") would be highly appreciated. Thank you.
Cheers!
Harsh