Infopath: Display various information in one box

Posted on 2008-11-03
Last Modified: 2012-05-05
Hi All,

I have an infopath form which users fill in various information in various fields.

What I want to do if possible to for each of those responses to populate in a text box hidden on the form.  So user fills in name, location, question but I want all of those details to appear in a single text box on the form formatted with a break between each answer.  Is it possible to do this?

So for instance in the box at the bottom it would show

Jon Smith


How do we do this?
Question by:smods
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 25

Expert Comment

ID: 22866174
Try this. Go to Form options>Open and Save>Rules. Create a new rule. Add Action>Set a Fields Value.
Pick the field in question in the first box. Select the FX button for the second and choose add function. Select concat.
Where you need a double click to enter a field, do so for the first field and select the first field you want formatted. Once that is done, after the comma for the first field type the following EXACTLY:
" ", (that's "space",).
Then select the second field and repeat the process until you have all the fields.

Author Comment

ID: 22866233
Sorry,  that's my fault for not making it clear.

I need a carriage return between each line.  Not a space
LVL 25

Accepted Solution

Robbie_Leggett earned 500 total points
ID: 22866280
You're going to need code then. Look here:
Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.


Author Comment

ID: 22866325

As I have never really used infopath how/where do I insert this code? :D
LVL 25

Expert Comment

ID: 22866333
Tool>Form Options>Programming>VSTA.
Have a look in there. You really want to read up on this before you do anything. is a great site.

Author Comment

ID: 22866608
I'm sure it is as I originally found this through google but I don't have the time to learn about the programming aspect.  I can see how I need to change the code but where to put it is what I am struggling with.  I don't have that path you have mentioned.

I have tools > Programming > On Load Event / On Switch Views Event / On Context Change Event / On Sign Event / Microsoft Script Editor
LVL 25

Expert Comment

ID: 22866921
You need microsoft script editor.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

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…
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

695 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