General

Re: Copy data from first field in the repeating table to following fields

Hilary Stoupa — Mon, 25 Apr 2011 19:31:39 GMT

Oh, that's awesome! Glad you got it figured out!

Re: Copy data from first field in the repeating table to following fields

Toni Green — Mon, 25 Apr 2011 19:29:03 GMT

Thank you Thank you I get it now! and it works! I really appreciate it!

Re: Copy data from first field in the repeating table to following fields

Hilary Stoupa — Mon, 25 Apr 2011 18:14:46 GMT

So following Skarn's syntax, your first rule would set the PlanName field (I'm assuming there are no spaces in your field names, since they are not allowed? I'm also going to assume your fields are using the "my" namespace. You may want to right click on one, and select "Copy XPath" so you can paste the XPath in a text editor and see what it looks like) to ../my:Tasks[1]/my:PlanName. Your second rule would set AITName = ../my:Tasks>[1]/my:AITName. Your third rule would set LOB = ../my:Tasks>[1]/my:LOB.

Re: Copy data from first field in the repeating table to following fields

Toni Green — Mon, 25 Apr 2011 16:42:31 GMT

Repeating table - Tasks

Field Name(s): Plan Name, AIT Name and LOB

There are three fields that need to be repeated on each row. Is that possible? I really appreciate the help!!!

Re: Copy data from first field in the repeating table to following fields

Hilary Stoupa — Mon, 25 Apr 2011 16:36:58 GMT

You'll need to manually enter the XPaths, I'm afraid. What's the name of your repeating group and field?

Re: Copy data from first field in the repeating table to following fields

Toni Green — Mon, 25 Apr 2011 16:05:48 GMT

I did, can you tell me how to by note using the insert formula dialog box? WHat function's do I use?

Re: Copy data from first field in the repeating table to following fields

Hilary Stoupa — Mon, 25 Apr 2011 15:23:49 GMT

Skarn's reply was for using rules. Add the rule to the repeating group itself.

Re: Copy data from first field in the repeating table to following fields

Toni Green — Mon, 25 Apr 2011 13:31:49 GMT

Thank you for the response. I know I am probably being a little stupid, but I am not sure what this means. I am adding the fields in the rules area. Do I need to copy this code? What function is this? Sorry for being a little slow on this. Thank you again for your help

Re: Copy data from first field in the repeating table to following fields

Skarn — Fri, 22 Apr 2011 22:52:18 GMT

Hi Aggreen,

On the Repeating Table Properties - Rules button - No condition - Set

my:<field1name> = ../my:<repeatingTablename>[1]/my:<field1name>
my:<field2name> = ../my:<repeatingTablename>[1]/my:<field2name>

The above commands tell the repeating table that each time a row is added, retrieve the value of the first row ([1] part), field and assign it to the new row field.

Hope this helps/works.

Copy data from first field in the repeating table to following fields

Toni Green — Fri, 22 Apr 2011 13:44:37 GMT

Here is what I am trying to accomplish. I have a repeating table with 50+ fields. It is a task form that provides data to our implementers. There are several fields that will continually be the same in all rows, but I will not know that data until the first row is filled out. How do I ask the form to copy that field data to each added row for that particular field.I am a newbie to InfoPath and know just enough to be dangerous. I am not a developer and I really do not write code.Is this something that can be done and if so I would much appreciate your help :-)T