Re: Eval and Concat in Repeating Table

JenniferLindsay — Sat, 06 Sep 2014 00:30:10 GMT

A few questions: how does the user select courses? Is there a check box of some sort in each row of the repeating table and the user checks the boxes for the rows he/she wants to select?

Why not simply include the following rule on your repeating group:

my:CatalogNumber = xdXDocument:GetDOM("ClusterPathways")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Catalog_x0020_Number[../d:Courses = xdXDocument:get-DOM()/my:myFields/my:ClusterPathways/my:Courses]

And then also put a rule on the repeating group to hide the CatalogNumber field if the repeating group row is not selected?

Eval and Concat in Repeating Table

Firthouse — Thu, 28 Aug 2014 19:41:36 GMT

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?

Code

Re: Eval and Concat in Repeating Table

Eval and Concat in Repeating Table