2 Replies Latest reply on Jul 19, 2013 7:09 AM by Lestiege

Merging multiple Fields to one Field

Lestiege Jul 18, 2013 11:51 AM

Title

Post

I want to be able to merge options from multiple fields into one field. For example, I have four separate fields (each with a dropdown menu with multiple options) and I want to be able to make the fifth field a combination of the four fields options based on how I select the options for each of the four fields.

For example, if I have "field 1" with the drop down menu options a b c d

"field 2" drop down menu options e f g h

"field 3" drop down menu options i j k l

"field 4" drop down menu options m n o p

When I select "a" under field one, "e" under field two, "i" under field three, and "m" under field four, I want field 5 to automatically say "aeim"

Is there a possbile way to achieve this? Any help is appreciated!!!

1. Re: Merging multiple Fields to one Field

philmodjunk Jul 18, 2013 12:02 PM (in response to Lestiege)

     What does this concatenation of values accomplish for you? Depending on why you need this, the calculation field may not be needed at all.

     That said, field 5 can be defined as a calculation field with Text selected as the result type:

     Field 1 & Field 2 & Field 3 & field 4
Like Show 0 Likes(0)

Actions
2. Re: Merging multiple Fields to one Field

Lestiege Jul 19, 2013 7:09 AM (in response to Lestiege)

I am attempting to create a naming system for protein conjugates, there are a huge variety of possible combinations and this was the best system I could come up with!

Thanks in advance for your help!
Like Show 0 Likes(0)

Actions

Go to original post