cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Jack2019
Nintex Newbie

combine two fields based on choice and show as one in sharepoint list

Jump to solution

One nintex form (2013) with Client Choice ( School/External), if select School, then School Name(single line of text) is available from a selection list (List Lookup with source list); if select External, then Company Name (single line of text) can be filled in. The customer wants to combine "Company Name" and "School Name" fields into a new field (School_Name) and then shows it into Sharepoint list (either Company Name or School Name based on Client Choice- School/External. Anyone has idea to do it? I tried a calcualted valve control as new field (School_Name) , but does not work. below pictures shows requirementschoice-p.jpgchoice-e.jpgSPlist.jpg

 

 

Labels: (1)
0 Kudos
Reply
1 Reply
Nintex Employee
Nintex Employee

Re: combine two fields based on choice and show as one in sharepoint list

Jump to solution

Hi,

I think you were on the right track using a calculated value control to combine the outputs.

My form looks like:

FormPic.png

Clicking school shows the dropdown and clicking External shows a text box.

The calculated value brings them together.

If(equals(SorE,"School"),SorE+" "+SName,SorE+" "+CompName)

The formula is saying "If the radio button is School then join school and what ever value is in the drop down, if its not school then join External and what ever value is in the Text control"

SorE is the School or External Radio button.

Sname is the School name from the dropdown.

CompName in the company name single lines of text control.

Connect that to a column in Sharepoint and thats it.

Attached my example form.  Just connect the Calculated value control to a column in your list and test if you need to.

 

 

0 Kudos
Reply