InfoPath value help

[Jesslyn]

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]

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]

OOOPPPSSS. i forgot to add the link.. sorry

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

 

[Jesslyn]

Where is the link?