 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / April 2006Automatically populate field with multiple lines
I'd like to populate a field with multiple lines of text. For example, if the user chooses the name John Doe from a drop-down list, I would like John Doe's "info" field to populate with his contact information, formatted like this: 123 Main Street, Suite 100 Elmwood, Texas 12345 Phone: 123-456-7890 Fax: 987-654-3210 Is there any way to do that? Thanks. Hey Janie, You should be able to do this using a "concat " function on the field your wanting the data to appear in. You would also need to use some filters on the values you specify in the concat statement. If you need more info let me know and I'll shoot a post up for you Cheers Ben Walters > I'd like to populate a field with multiple lines of text. For example, if > the user chooses the name John Doe from a drop-down list, I would like John [quoted text clipped - 7 lines] > > Is there any way to do that? Thanks. yes Janie u should be able to do this by using the concat "formula". u will add something like invisible fields that will not show on the form (either by deleting them after specifying everything or by creating them from the right pane) and then add the control in which u want all the info to appear, go to its properties, and concat all the fields u want. in between the fields, add " " to have spaces between words and/or numbers check this post if u need more info about populating fields from secondary data: http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.infopath&l ang=en&cr=US&mid=8f789d22-62ea-4c8b-baa0-c8a81ba519e4 (thanx to Adam for that:) ) hope it helps.. Dixieee Thanks for the info. A couple more questions. How do I get the information to appear on separate lines instead of simply having spaces between the words? And this may complicate things.... Here's the deal... I have a list of contacts in a Sharepoint custom list. If someone chooses "John Doe" I want his address to automatically appear in the address field. Should I store his address in the same custom list --- or where? Thanks! > yes Janie u should be able to do this by using the concat "formula". u will > add something like invisible fields that will not show on the form (either by [quoted text clipped - 10 lines] > hope it helps.. > Dixieee Could I use Master/Detail to do this? I have tried, but I'm confused as to how to bind the Master to a field. What kind of field do I create that can hold an address? > yes Janie u should be able to do this by using the concat "formula". u will > add something like invisible fields that will not show on the form (either by [quoted text clipped - 10 lines] > hope it helps.. > Dixieee Thanks for the info. A couple more questions. How do I get the information to appear on separate lines instead of simply having spaces between the words? And this may complicate things.... Here's the deal... I have a list of contacts in a Sharepoint custom list. If someone chooses "John Doe" I want his address to automatically appear in the address field. Should I store his address in the same custom list --- or where? Thanks! > Hey Janie, > You should be able to do this using a "concat " function on the field your [quoted text clipped - 16 lines] > > > > Is there any way to do that? Thanks. Hey Janie, You should be able to do this using a "concat " function on the field your wanting the data to appear in. You would also need to use some filters on the values you specify in the concat statement. If you need more info let me know and I'll shoot a post up for you Cheers Ben Walters > I'd like to populate a field with multiple lines of text. For example, if > the user chooses the name John Doe from a drop-down list, I would like John [quoted text clipped - 7 lines] > > Is there any way to do that? Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.