Hi Clayton,
I have a drop down list box which contains e-mail addresses, taken from a list in Sharepoint.
The user opens the form, fills out a few boxes and chooses their managers e-mail address - simple. Form submits ok, but when the manager goes into the form to approve it, the e-mail address field is blank!
Thus, if the form is submitted, opened for approval/rejection then saved, the e-mail address data is blank on the form and then is removed in the list in Sharepoint. Is there a method of getting the form to retain the data held in this field?
The others fields are all ok, such as requester name, department... (as this other data is taken directly from Active Directory), so any data in these fields are still there when the form is opened. The list however is not! :(
Also, on the form we have the manager name (taken from Active Directory) but we have struggled to get the managers e-mail address (As this is not available in Active Directory - just the managers name). Obviously, the manager does have an e-mail address, but this is available only on their AD profile. Is there a good method of creating another box on the form (lets say a text box below the managers name) which then takes the manager name as it is shown (i.e. James BRANCH) and then adds '@mycompany.com' onto the end of it, thus creating an e-mail address??
We'd then use this e-mail address box rather than the drop down list as mentioned above as the initial address for our workflow. It would be better too, as the user doesn't have to pick from a list!
We've tried a few methods, none of which seem to work!
Your help would be very much appreciated!
Thanks Clayton,
James