SharePoint Integration

Re: How can I write values in special rows of a repeating table?

phillil — Thu, 03 Apr 2014 07:56:47 GMT

Many thanks for posting this ingenious solution - overjoyed having got it to work late last night!!

However after publishing on my return to work this morning, the disappointment of it not being supported in a browser... :(

You mentioned that code could be used - what would I need to do to enable code?? Personally I am not permitted to use SharePoint Designer, but I could ask my colleagues in IS to assist.

Many thanks

Lee

Re: How can I write values in special rows of a repeating table?

Jimmy — Tue, 06 Apr 2010 08:20:34 GMT

The method I described can't be used in browser-enabled forms. For browser forms, you you will either need to use code, or you can use the handy SetValue command provided by qRules:

http://www.qdabra.com/en/products/qRules.aspx

Re: How can I write values in special rows of a repeating table?

amerrill — Mon, 05 Apr 2010 20:01:15 GMT

Is there a browser compatible way to write this type of XPath in InfoPath 2007? The code you provided works in the InfoPath client but does not pass the browser compatibility checks.

Re: How can I write values in special rows of a repeating table?

Reztips — Tue, 10 Nov 2009 20:41:48 GMT

Hi Jimmy...just reading this post....a year later. :)

Your solution seems to work for infopath forms. However, I get the following error in the browser compatability section since I am developing a web-based form:

"The following expression could not be parsed because of a syntax error or because it uses and undefined namespace prefix or unsupported function: xdXDocument:GetDOM("AuditList")/Batch/Method/Field[1]

Here is the entire XML entry:

<xsf:assignmentAction targetField="xdXDocument:GetDOM("AuditList")/Batch/Method/Field[1]" expression="xdDate:Now()"></xsf:assignmentAction>

I have also Tried this:

<xsf:assignmentAction targetField="xdXDocument:GetDOM("AuditList")/Batch[1]/Method/Field" expression="xdDate:Now()"></xsf:assignmentAction>

I have also Tried this:

<xsf:assignmentAction targetField="xdXDocument:GetDOM("AuditList")/Batch/Method[1]/Field" expression="xdDate:Now()"></xsf:assignmentAction>

"AuditList" is an XML file depicting a SharePoint List.

Is there a web-based soluton for this?

Re: How can I write values in special rows of a repeating table?

Uoikcuff — Thu, 07 May 2009 19:55:04 GMT

This is great. If I wanted to do this repeatedly, could I use an integer text field, for example my:index, that is increased when a button is clicked?

Re: How can I write values in special rows of a repeating table?

inge_koschmi — Mon, 27 Oct 2008 10:13:27 GMT

Hi Jimmy,

that`s exactly I was looking for! It works very well. Thank you!

Re: How can I write values in special rows of a repeating table?

Jimmy — Fri, 24 Oct 2008 14:56:56 GMT

If I understand your question correctly, then there is a way to do this without code, but I think you will need to get involved with the form's source just a little bit.

I have a form with two text fields, field1 and field2, and a single-column repeating table bound to /my:myFields/my:group1/my:group2(repeating). The column's nodes are bound to my:group2/my:field3

I add a button and give it two rules:

Set my:field3 to value of my:field1
Set my:field3 to value of my:field2

I preview the form, add several rows to the repeating table, enter values for field1 and field2 and click the button. All rows of the table are filled with the value of field2. This is obviously not what we want, as I'm sure you've guessed.

I now go back to design mode, and select Save as Source Files... from the File menu and choose a folder for their destination. I close InfoPath.

I browse to the folder and open the manifest.xsf file in an XML editor (a text editor would also work).

I search for the text "ruleset" until I find a section of text that looks like this:

<xsf:ruleSets>
   <xsf:ruleSet name="ruleSet_1">
          <xsf:rule caption="Rule 1" isEnabled="yes">
               <xsf:assignmentAction targetField="my:group1/my:group2/my:field3" expression="my:field1"></xsf:assignmentAction>
          </xsf:rule>
          <xsf:rule caption="Rule 2" isEnabled="yes">
               <xsf:assignmentAction targetField="my:group1/my:group2/my:field3" expression="my:field2"></xsf:assignmentAction>
          </xsf:rule>
     </xsf:ruleSet>
</xsf:ruleSets>

The salient parts are the <xsf:assignmentAction> nodes. They are telling the form to copy field1 and field2 into my:group1/my:group2/my:field3 whenever these rules are carried out. Now I add subscripts after my:group2 in the targetField attributes to specify specific rows, like this:

<xsf:ruleSets>
   <xsf:ruleSet name="ruleSet_1">
          <xsf:rule caption="Rule 1" isEnabled="yes">
               <xsf:assignmentAction targetField="my:group1/my:group2[1]/my:field3" expression="my:field1"></xsf:assignmentAction>
          </xsf:rule>
          <xsf:rule caption="Rule 2" isEnabled="yes">
               <xsf:assignmentAction targetField="my:group1/my:group2[2]/my:field3" expression="my:field2"></xsf:assignmentAction>
          </xsf:rule>
     </xsf:ruleSet>
</xsf:ruleSets>

Now I save and close the manifest, right click the file, choose Design, and preview the form. I repeat the steps I performed during the last preview, and this time only the first two rows are populated. I close the preview and choose File->Save As... to re-save the form as an .xsn file.

How can I write values in special rows of a repeating table?

inge_koschmi — Fri, 10 Oct 2008 13:45:44 GMT

Hello,

I want to use a WebService to write data in a special Sharepoint column. Therefore I have an XML-File as secondary datasource which is implemented in the form as repeating table (similar to this description: http://blogs.msdn.com/infopath/archive/2007/03/26/submitting-to-a-sharepoint-list.aspx)

But now the problem: I want to write content into the repeating table. The values are already in the form -> two text fields (field1/field2). But I can`t find any way to tell InfoPath: Write the content of field 1 to row 1 and field 2 to row 2

It would be nice, if anybody could provide a codeless solution for this problem!

Can give a xPath to field1 in the XML-Container? if yes => how? Or is there any way to filter the target field in the rule "set a field`s value"?