Re: How to combine Two Fields

Bre Huston — Mon, 08 Sep 2014 16:43:51 GMT

Hello Zippy,

Overall I would say that it would be easier to have the entries as separate fields, because then you can promote them in SharePoint columns, and know whether the user entered the data or picked from a list. This would be especially important if the user entered data that was not an exact match to the course/course number. However, it may be good to have a user select from an option button or similar logic whether they would like to pick from the dropdown or create a manual entry.

For your third question, you could use the option selected to hide/show the entry to determine the value of the calculation in your subsequent view. This would be done with rules and logic, so if the selection is "manual" set the calculated field to concat(fieldchoice1, fieldchoice2).

Here is another resource that may be helpful: http://www.infopathdev.com/forums/p/28750/98716.aspx#98716

Thanks!
Bre

How to combine Two Fields

Zippy — Thu, 14 Aug 2014 14:41:57 GMT

Background: I have limited knowledge how best to do this and need suggestions. I currently have a InfoPath 2010 form users submit their training request with. They type in the name of a course and the course number along with other items. I have been asked to include another field containing a long dropdown list of existing courses to select from. The user will either make a manual entry for courses not on the list or select one from the list, but not both. Once the data has been submitted to SharePoint 2010 it goes through a three-step workflow approval process.

Can I use the current course name and course number field to make a manual entry but also have the ability to select from a dropdown list in the same field? Or, is it better to create separate fields?
In the SharePoint List where these multiple form submissions reside, what is the best way to display both an existing course name and number that was manually entered and the courses selected from the new dropdown list? Just use separate fields?
If I add this new dropdown field can I then create a custom view that includes a field that combines both these course names fields but using only the one that is not blank? Not sure of how best to develop this.
How would I create a second course number field, tied to this new “course name” dropdown field?

I want it to auto populate this new field with the courses course number when the course name was selected from the dropdown list?
The course names/numbers that I need to create the dropdown list with will contain the below two columns examples.

Course Number
ABC555003
Course Name
(ABC555003) SharePoint for Dummies

Thank you.

SharePoint Integration

Re: How to combine Two Fields

How to combine Two Fields