General

Re: How can I set the value in a Repeating Table Textbox Using a Rule

bissettbd — Mon, 03 Jan 2011 18:12:34 GMT

Good to know. Thank You for your help.

Re: How can I set the value in a Repeating Table Textbox Using a Rule

Alec Pojidaev — Mon, 03 Jan 2011 18:02:13 GMT

Yes, this is limitation of secondary data sources.

The "ue" thing is not a typo. It's a minimal set of chars allowing to distingiush True from False in this expression.

Re: How can I set the value in a Repeating Table Textbox Using a Rule

bissettbd — Mon, 03 Jan 2011 16:57:37 GMT

Alex,

I did download your sample which was brilliant but unfortunately does not seem to work in my case.

Because My Repeating Group (Table) is linked to an XML CAML data connection, the Default Value Function (Fx) button under the Data Tab is greyed out, not allowing me to add a formula such as substring-before(substring-after(concat(index = count(preceding-sibling::*[local-name() = "Field(XML_CAML_Read)"]), ThisPONumber, "true", ., "true"), "true"), "true")

Any other ideas, BTW you have a Typo "ue" instead of "True" in the example formula: substring-before(substring-after(concat(index = count(preceding-sibling::*[local-name() = "RepeatingGroup"]), NewValue, "true", ., "true"), "ue"), "true") - but it still works.

Thanks,

Brian

Re: How can I set the value in a Repeating Table Textbox Using a Rule

Alec Pojidaev — Fri, 17 Dec 2010 16:43:02 GMT

Take a look at this:

http://alecpojidaev.wordpress.com/2010/01/07/accessing-previous-rows-in-repeating-group-for-browser-enabled-forms/

Re: How can I set the value in a Repeating Table Textbox Using a Rule

bissettbd — Fri, 17 Dec 2010 13:40:47 GMT

Patrick,

Thanks for offering to look at this. You and Hilary have been really helpful. When our budget is approved I am going to try and obtain a copy of qRules. InfoPath is a product with so much potential but is seems very immature in terms of functionality. I am hoping qRules will help us fix some of that.

I have attached the form I am working on.

Many Thanks,

Brian

Re: How can I set the value in a Repeating Table Textbox Using a Rule

Patrick Halstead — Fri, 17 Dec 2010 04:08:51 GMT

You can set a value using xpath filtering on the row but the row has to exist. In addition the filtering can be tricky and doesn't work in all cases.

A simpler solution (which would also simplify your previous challenge) would be just to use qRules. qRules comes with a SubmitToSharePointList command as well as Insert and SetValue tha can be used all via rules.

Otherwise, please attach a sample XSN and we'll take a look over the weekend.

How can I set the value in a Repeating Table Textbox Using a Rule

bissettbd — Thu, 16 Dec 2010 23:13:06 GMT

I need to write a new value to a SharePoint List and I am doing this via a repeating form.

See this earlier post: http://www.infopathdev.com/forums/p/17838/62185.aspx#62185

The problem is the user will not type this information in to the repeating table, I need it to be copied to the repeating table using a Rule.

Setting the value in a repeating table does not seem to work using Rules.

What am I missing?

Thanks