Based on the Cluster selection Pathways is listed and based
on the pathways selection Programs are listed and based on that selection
Courses are listed. Then User selects the courses they want.
When user select insert item, the combination of cluster,
pathways, programs and courses are added to the repeating table. I want to
display Catalog Number corresponding to the Courses selected. I am getting the
first Catalog No duplicated for all the rows.
Formula that is used in the Rules to set Catalog Number
field in Repeating Table:
eval(eval(Courses[. != ""],
'concat(xdXDocument:GetDOM("ClusterPathways")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Catalog_x0020_Number[xdXDocument:get-DOM()/my:myFields/my:ClusterPathways/my:Courses
= ../d:Courses], ";")'), "..")
I am getting duplicated Catalog Number for all the selected Courses.
Course - Catalog Number
Math 101 - 1000101
English 101 - 1000101
Science 101 - 1000101
How I can display Catalog Number that is correspondence to
every Courses selected?