Controls

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

Hilary Stoupa — Thu, 23 Jan 2020 20:27:33 GMT

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.

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

Ghoztrider — Thu, 23 Jan 2020 20:15:54 GMT

That did it! Thank you so much!

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

Hilary Stoupa — Thu, 23 Jan 2020 20:08:27 GMT

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

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

Ghoztrider — Thu, 23 Jan 2020 19:51:14 GMT

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.

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

Hilary Stoupa — Thu, 23 Jan 2020 18:23:15 GMT

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

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

Ghoztrider — Thu, 23 Jan 2020 16:58:55 GMT

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.

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

Hilary Stoupa — Wed, 22 Jan 2020 23:40:17 GMT

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

Merge Repeating field Data into Text Field\Calculated Value

Ghoztrider — Tue, 21 Jan 2020 15:40:32 GMT

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.