General

Re: View repeated fields value in textbox

Kaoru Okumura — Fri, 29 Jan 2016 23:05:25 GMT

well, if you need new line, at least we need Rich Text field. Rich Text field is tricky, so I switched RichText into just text. you can try it back, and see if new line works.

Re: View repeated fields value in textbox

waelt — Fri, 29 Jan 2016 22:45:11 GMT

I'm trying to add new line between specific fields using this inside concat but it is not working xdXDocument:GetDOM("characters")/lookups/characters/@crlf

Re: View repeated fields value in textbox

waelt — Fri, 29 Jan 2016 22:34:17 GMT

Thank you was able to do it thanks to your help

Re: View repeated fields value in textbox

Kaoru Okumura — Fri, 29 Jan 2016 22:31:11 GMT

Same to non-repeating fields ;-) you can combine them using concat()

Re: View repeated fields value in textbox

waelt — Fri, 29 Jan 2016 16:47:40 GMT

Got it .. Thank you so much for your help :) Same goes with non repeatable fields ?

Re: View repeated fields value in textbox

Kaoru Okumura — Fri, 29 Jan 2016 05:11:19 GMT

"additional field that is from a different group" -- if you'd like to add it from repeating group, first, create similar eval(eval()) for the repeating group. and then concatenate these 2 together. Once you know how to handle repeating table, then you can apply it.

for example, the following expression gives concatenated items of interest, and plus concatenated AnalystName Present.

concat(xdMath:Eval(xdMath:Eval(../my:ItemsOfInterestGroup/my:ItemsOfInterestSub, 'concat(my:IoI-TicketNum, " ", my:IoI-EventTitle, " ", my:IoI-Priority, " ", my:IoI-Status, " ", my:IoI-Remarks, "; ")'), ".."), " /", xdMath:Eval(xdMath:Eval(../my:AnalystsOnShift/my:AnalystsOnShift-Sub, 'concat(my:AnalystName-Present, ", " )'), ".."))

Re: View repeated fields value in textbox

waelt — Fri, 29 Jan 2016 01:55:13 GMT

Thank you so much, really appreciate your help. What if I wanted to have an additional field that is from a different group ? Would that be achievable using same method ?

Re: View repeated fields value in textbox

Kaoru Okumura — Fri, 29 Jan 2016 01:27:57 GMT

Attached the modified form that shows concatenated string ExecSum. Default value is set as:

xdMath:Eval(xdMath:Eval(../my:ItemsOfInterestGroup/my:ItemsOfInterestSub, 'concat(my:IoI-TicketNum, " ", my:IoI-EventTitle, " ", my:IoI-Priority, " ", my:IoI-Status, " ", my:IoI-Remarks, "; ")'), "..")

and you may modify concat part to make string you like.

'concat(my:IoI-TicketNum, " ", my:IoI-EventTitle, " ", my:IoI-Priority, " ", my:IoI-Status, " ", my:IoI-Remarks, "; ")

I would be safer to set the fields which contains concatenated string (currently ExecSum) as text, rather than rich text. and also you may want show this to uses as Calculated Value instead of text box. in case of text box, user may enter/modify it, which causes inconsistency between the repeating table. tnx

Re: View repeated fields value in textbox

waelt — Fri, 29 Jan 2016 00:59:25 GMT

I have uploaded the file, kindly check.. I would like to have Ticket# and other fields to be copied to the Executive Summary textbox Thank you

Re: View repeated fields value in textbox

Kaoru Okumura — Fri, 29 Jan 2016 00:52:56 GMT

I understand it's tricky and setting the parameters for eval is a bit difficult first. You can upload your InfoPath file using "Option" tab. Then we can take a look at it.... tnx

Re: View repeated fields value in textbox

waelt — Fri, 29 Jan 2016 00:44:16 GMT

Thank you for helping out. I'm trying to make it work with my form but it isn't working.. What does "my" stand for ? I'm replacing item with my repeating group, and text with the field I want to repeat, I'm receiving an error ("ItemsOfInterestSub" does not point to a valid location path of a field or group.). Even though I have typed the group name correctly ... My form structure ShiftTurn -ItemsOfInterestGroup --ItemsOfInterestSub (Repeated Table) ---TicketNumber (Field I want to take its value in each repeat) -Summary (The textbox where I want to print TicketNumbers) How can I make your function work in that case ? Thank you in advance

Re: View repeated fields value in textbox

Kaoru Okumura — Thu, 28 Jan 2016 06:08:55 GMT

Assuming you have InfoPath form library, and may add another field to show all repeated fields, I'd use concatenation function to show repeated fields.

Sample form is attached,

Let's say xpath of the target field: /my:myFields/my:items/my:item/my:text, and /my:myFields/my:items/my:item is repeating group.

Please see the default value of Concatenated_text, which is

eval(eval(item, 'concat(my:text, ", ")'), "..")

This generates the comma separated concatenation of fields my:text under repeating group item , and automatically save it to Concatenated_text.

View repeated fields value in textbox

waelt — Thu, 28 Jan 2016 05:45:07 GMT

Is it possible to view repeated fields values in a textbox in the same document? I was able to get the first value shown and when ever I repeat the table and add a new value the old value in the textbox would be replaced with the newer one... Any clues please ? Thank you