Retrieve values in a repeating table - InfoPath Dev
in

InfoPath Dev

Retrieve values in a repeating table

Last post 01-31-2011 08:33 AM by L'egyptien. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-31-2011 08:11 AM

    Retrieve values in a repeating table

    Hello everyone,

     With my subject, you certainly think that I didn't search the answer, but it's completely wrong, I pass the all day to find it, but without success!

    I'm here because I'm going crazy with InfoPath 2007, maybe it's because I'm a newbie!

    So, in Infopath, I 've create a simple repeating table, and I just want to see all values in the tables to see if one specific is present.

    Here is my structure:

    Attendees (group)

    Attendee (repeating group)

    Location (Field - DropDown list retrieve by sharepoitn list)

    NumberOfSeat (Field)

    PreferredRoom (Field)

    ConcatLocation

     I wanted to concat all location values in "ConcatLocation", but with this formula behind, I only retrieve the first row each time. For example, if the user add 3 locations in this order (France, UK, Spain), the result is : "France-France-France"  ???!!!!!

    eval(eval(Attendee; 'concat(../my:Attendee/my:Location, "-")'); "..") 

    Can anyone help me please ?

    Many thanks by advance! 

     

     

     

    -"I spent a lot of money on booze, birds and fast cars. The rest I just squandered."
    -"I gave up women and alcohol - it was the worst 20 minutes of my life"

    George Best
  • 01-31-2011 08:23 AM In reply to

    Re: Retrieve values in a repeating table

    It should be my:Location, not ../my:Attendee/my:Location.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 01-31-2011 08:33 AM In reply to

    Re: Retrieve values in a repeating table

    So many thanks!!!!  it works!

     sorry to be a newbie ... but I selected the field by the button "Add a Field" and the formula appears by the way I wrote!

     

    Thanks again!

     

    -"I spent a lot of money on booze, birds and fast cars. The rest I just squandered."
    -"I gave up women and alcohol - it was the worst 20 minutes of my life"

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