Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / May 2007

Tip: Looking for answers? Try searching our database.

InfoPath value help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jesslyn - 17 May 2007 19:08 GMT
I have created an InfoPath 2003 form that I really should have stayed away
from or gotten one of the developers to do as I believe I am in WAY over my
head, but here goes:

My form pulls the information from a Sharepoint 2003 list into a dropdown
listbox.  The value is one column (email address), however the display name
is another (user name).  I need to keep the value as the email address so I
can email the form on submit, but show the displayname so the user knows who
they are choosing.  All works well with that scenario, however, I am pulling
the information from that field back into my Sharepoint forms library and
want to use the same information to sort for the users.  When pulling that
field onto the document library, it displays the email address.  Is there a
way to set a hidden field to the correct value, displayname, when the
original value is chosen?  THat way, I can pull that field into my form
library as a column and display the information correctly.
esebastian@esolutionsgroup.ca - 17 May 2007 20:15 GMT
I had to do something similar, i needed both the text and value for
later use within my form. If I am correct in what you want to do then
it's similar to what i did (however i don't use sharepoint at all so
i'm not sure how that affects the form) anyways give this a try.
You will need to create a new field to store the display name and then
follow the instructions at the following link (you wont' have to do
everything she says, at the bottom she explains how to use the
"Current" function to populate a fields value, search for current and
you will get to where you need to go.)
SYM Wong A Ton has posted many helpful tips and tricks and this is one
by her.
let me know if this helps.
Thanks
esebastian@esolutionsgroup.ca - 17 May 2007 20:16 GMT
OOOPPPSSS. i forgot to add the link.. sorry

http://enterprise-solutions.swits.net/infopath/shrinking-dropdown-list-repeating
-table.htm

Jesslyn - 17 May 2007 20:29 GMT
Where is the link?

> I had to do something similar, i needed both the text and value for
> later use within my form. If I am correct in what you want to do then
[quoted text clipped - 9 lines]
> let me know if this helps.
> Thanks
 
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.