Update Secondary data Source Field - InfoPath Dev
in

InfoPath Dev

Update Secondary data Source Field

Last post 10-28-2009 08:58 AM by Greg Collins. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 10-21-2009 04:48 AM

    • bcmps
    • Not Ranked
    • Joined on 07-12-2009
    • Posts 11

    Update Secondary data Source Field

    Hi,

    I configured this xml file as secondary data connection to update a SharePoint list, as explained by Matt Faus here (Add SharePoint List Items with InfoPath).

    <?xml version="1.0" encoding="UTF-8"?>
    <Batch OnError="Continue">
        <Method ID="1" Cmd="New">
            <Field Name="ID"></Field>
            <Field Name="Customer"></Field>    
        </Method>
    </Batch>

    The form received a repeating table with columns "Name" and "Field".

    When I open the form to fill out, the column "Name" receives the values ID and Customer. The column "Field" receives the values that I type.
    Is there a way to use rules or code to set one of the Field values to receive text from a Text box?

     

    Thanks,

    Bruno

  • 10-21-2009 02:51 PM In reply to

    Re: Update Secondary data Source Field

    Unfortunately with rules, InfoPath treats repeating nodes with an all-or-nothing attitude. There is no built-in filtering for a rule to specify a particular repeating node to update, rather they are all updated. This is unfortunate behavior in my opinion.

    Some users have reportedly modified the manifest.xsf file to manually add in a filter to the rule xpath. The other option is to use Qdabra qRules (it's either 1.8 or 2.0 that gives the ability to get around this--not sure which) or write your own code.

  • 10-26-2009 06:11 AM In reply to

    • bcmps
    • Not Ranked
    • Joined on 07-12-2009
    • Posts 11

    Re: Update Secondary data Source Field

    Thanks, Greg!
  • 10-28-2009 08:58 AM In reply to

    Re: Update Secondary data Source Field

    Glad to help!

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.