Merge Repeating field Data into Text Field\Calculated Value - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Merge Repeating field Data into Text Field\Calculated Value

Last post 01-23-2020 12:27 PM by Hilary Stoupa. 7 replies.
Page 1 of 1 (8 items)
Sort Posts: Previous Next
  • 01-21-2020 07:40 AM

    Merge Repeating field Data into Text Field\Calculated Value

     Is there a way to display the data from a repeating field into one control (textbox or calculated field) with data separated by a comma? Similar to what you can do when displaying it in a SharePoint list (merge data) from an InfoPath form.

    Filed under: ,
  • 01-22-2020 03:40 PM In reply to

    Re: Merge Repeating field Data into Text Field\Calculated Value

    Yeah, you can use a double eval for this: http://tinkerersjournal.blogspot.com/2013/01/codeless-double-eval.html
    Hilary Stoupa

  • 01-23-2020 08:58 AM In reply to

    Re: Merge Repeating field Data into Text Field\Calculated Value

     Thanks Hilary! I got most of this to work. I get the intended concatenation for each repeating data entry, but it always grabs the first piece of data, for instance if my first input was 1111 and I added another row as 2222 the destination field would display 1111, 1111. I can't seem to get the right combination.

  • 01-23-2020 10:23 AM In reply to

    Re: Merge Repeating field Data into Text Field\Calculated Value

    What does your formula look like? Be sure to tick the edit XPath box so I can see the whole thing....
    Hilary Stoupa

  • 01-23-2020 11:51 AM In reply to

    Re: Merge Repeating field Data into Text Field\Calculated Value

     xdMath:Eval(xdMath:Eval(../../my:Toll_Free/my:TollFreeFields, 'concat(../../my:Toll_Free/my:TollFreeFields/my:TollFree, ", ")'), "..")

    "TollFree" being the field in the repeating table where input goes and "TollFreeFields" being the top level repeating table. Everything else I could think of throws an error.

  • 01-23-2020 12:08 PM In reply to

    Re: Merge Repeating field Data into Text Field\Calculated Value

    I think it would be: xdMath:Eval(xdMath:Eval(../../my:Toll_Free/my:TollFreeFields, 'concat(my:TollFree, ", ")'), "..")
    Hilary Stoupa

  • 01-23-2020 12:15 PM In reply to

    Re: Merge Repeating field Data into Text Field\Calculated Value

     That did it! Thank you so much!

  • 01-23-2020 12:27 PM In reply to

    Re: Merge Repeating field Data into Text Field\Calculated Value

    Happy to help - you can pick the repeating group with the field picker, but the path in the concat needs to be relative to that group (in this case, directly inside it) and needs to be manually typed in.
    Hilary Stoupa

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