Solved

Infopath: Display various information in one box

Posted on 2008-11-03
7
226 Views
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

Staines

How do we do this?
0
Comment
Question by:smods
  • 4
  • 3
7 Comments
 
LVL 25

Expert Comment

by:Robbie_Leggett
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.
 
:-)
0
 

Author Comment

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

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

Accepted Solution

by:
Robbie_Leggett earned 500 total points
ID: 22866280
You're going to need code then. Look here:
 
http://www.infopathdev.com/forums/p/1703/7630.aspx
 
:-)
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:smods
ID: 22866325
Thanks

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

Expert Comment

by:Robbie_Leggett
ID: 22866333
Tool>Form Options>Programming>VSTA.
 
Have a look in there. You really want to read up on this before you do anything.
 
www.infopathdev.com is a great site.
 
:-)
0
 

Author Comment

by:smods
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
0
 
LVL 25

Expert Comment

by:Robbie_Leggett
ID: 22866921
You need microsoft script editor.
 
:-)
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

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…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

757 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

20 Experts available now in Live!

Get 1:1 Help Now