values display in column

Netaji Junghari

Hi i have designed infopath form. There are two columns:

1. Column A (Drop-Down)

Values: Others

2. Column B (TextBox)- If Select "Others" from Column A then Column B will apprear and allow enter to value

when i submit form it display in SP list -Column A- Others

Trying to do whenever Column B appear after submit the value, that value also save in Column A.

It means Column A & Column B value would be save in Column A only and display in SP.

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhijeet Jadhav6y ago
Accepted answer
Netaji,

You can achieve the desired functionality as below.
1) Create another calculated column, which will show the actual response.
2) Now in the calculated column use the condition to select the value from column A or Column B based on conditional formula like : IF([ColumnA] <>"Others", [Column A], [Column B])

Verify the syntax from your end and modify it accordingly.
Netaji Junghari6y ago
Many Thanks Abhijeet for your help!:)
Abhijeet Jadhav6y ago
This will explain you the steps to add calculated column:
https://sharepoint.rackspace.com/calculated-columns-tutorial
Netaji Junghari6y ago
Hi Abhijeet, Thank you for your kind response. First i need to create calculated column as variable and apply the formula?