Solved

Infopath: Display various information in one box

Posted on 2008-11-03
7
229 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
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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…
This article describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

789 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