Eval and Concat in Repeating Table - InfoPath Dev
in

InfoPath Dev

Eval and Concat in Repeating Table

Last post 09-05-2014 05:30 PM by JenniferLindsay. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-28-2014 12:41 PM

    Eval and Concat in Repeating Table

     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?

  • 09-05-2014 05:30 PM In reply to

    Re: Eval and Concat in Repeating Table

    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?

    Jennifer Lindsay
    Qdabra® Software/InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.