Displaying Columns from Forms Library In InfoPath - InfoPath Dev
in

InfoPath Dev

Displaying Columns from Forms Library In InfoPath

Last post 05-06-2011 12:37 PM by Hilary Stoupa. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 05-05-2011 02:44 PM

    Displaying Columns from Forms Library In InfoPath

    This is going to sound like a really simple question, but here goes. I have 10 Fields in total. I have designed my InfoPath 2007 Browser form and submitting data from 2 of the fields to the Forms Library, works all hunk dory. Once the Form has submitted a Nintex workflow pulls in and populates the other 8 fields, which are custom columns. I can see that the workflow works fine when the form is submitted, so the information is there. Quite Simply, How do I show these fields that are not user inputted? This only has to be when the user reopens the form for the second time. Thanks
  • 05-05-2011 03:02 PM In reply to

    Re: Displaying Columns from Forms Library In InfoPath

    You can add a data connection to the library that includes these columns.

    The possible issue you may have is that in IP and ShP 2007, there is no way to return just the information about a single item. In 2010, you have the option of returning data about just this form when opened, so if you have form 1 in your library, and you open it, your secondary data connection returns just info for that form. You can also, in ShP 2010, use the OData service ListData.svc as a REST connection.

    In 2007, you'll either end up returning all items and using XPath filters to get just the data you want or using code (or qRules) with an owssvr data connection.....

    Hilary Stoupa

  • 05-06-2011 12:05 PM In reply to

    Re: Displaying Columns from Forms Library In InfoPath

    Solved: This turned to be a really simple fix without any data connections. To display Forms library columns in the InfoPath form, I did the following (Please excuse any ambiguity as this is from memory).

    1) Created a number of fields, on each, under 'display' ticked the box to make these 'Read Only'

    2) Published the form and under the 'Property promotion' made sure that all of these columns were able to be edited in Datasheetview.  (This is needed so that the workflow can update the columns).

    3) When publishing the form, I made sure that this created a new Document library. (This didnt seem to work when saving as a content type) and created new columns in the library.

    I then simply amended the Nintex workflow so that when a new Item was added to the forms library, this run the workflow and updated the relevant columns. 

    4) When I reopened the form, these were now showing the data from the newly updated columns. 

     

  • 05-06-2011 12:37 PM In reply to

    Re: Displaying Columns from Forms Library In InfoPath

    Hey, great idea! And thanks for posting your solution!
    Hilary Stoupa

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