Solved

Show List items in an Infopath Form

Posted on 2013-01-30
5
468 Views
Last Modified: 2013-07-24
Hi Experts,

I have an infopath form that I want employees to be able to open and answer some questions in a comments field under each question.

My problem is that I want the question to come from a list in the same subsite, but when employees answer the questions, does not send anything back to the list.

It will basically be a one stop shop where you can update and add questions that will automatically be displayed in any new forms.

Im guessing this would be using a repeating table, but how do you integrate data connections and form data in the one repeating table?

I know my wording isnt that clear, but struggling to put to paper what I want.

Thanks,
Lance
0
Comment
Question by:NTTldola
  • 2
  • 2
5 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 38838787
Hello,

Infopath MVP Patrick Halstead has a series of youtube clips on that topic. Go to http://www.youtube.com/playlist?list=PL581899A129522F53 and scroll down to  

InfoPath Surveys Part 1 - May 31, 2012 Webinar

then watch all the clips in sequence. They're worth it!

cheers, teylyn
0
 

Author Comment

by:NTTldola
ID: 38841673
Thanks Teylyn,

Was hoping for a solution not on YouTube (locked down at work). Are you able to suggest anything else?

Thanks,
Lance
0
 
LVL 3

Expert Comment

by:Brenda D
ID: 38889681
Lance, Can you give me more details? I'm not following you what you need. If need be draw it out and attach a picture here and I'll see what I can do to help you.
0
 

Author Comment

by:NTTldola
ID: 38891096
Hello,

I have an infopath form that is going to be basically a survey. It will have questions that prompt the user and then a comments box underneath each question.

I have placed all the questions in a list and I want to populate that form with the question from the list.

My problem is, I can have them appearing in the form using a repeating table, but the comments box cannot contain comments which are also attached to the external source and keep that user inputted info in the saved form.
0
 
LVL 3

Accepted Solution

by:
Brenda D earned 500 total points
ID: 39352786
how about just using a text box, allow it to be maximum length. then put a insert below it for further comments if needed. in your access table, create an additional field and create a query that will combine all the comments text boxes together as needed. ive done this with success and it works great. I just put in the query that if the first box is not null, but the second one is, then only add the first, otherwise concatenate the two and so forth with each text box.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 Searchbox Branding 11 44
Date Differences SSRS 3 59
VBA in SharePoint 3 39
Configure Sharepoint 2013 to allow Excel files to be edited online 9 57
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now