Incrementing a text field with a string based on answers in the form

[JamesWB]

Hi, I have a simple form with three questions, A, B and C, each of which has two possible ENUM values, A1/A2, B1/B2 and C1/C2.

When each one is selected down the form, I want a field Counter to update with a string that builds as they go down the form. For example, if A is selected A1, B is selected B2 and C is selected C1, the outcome in counter would be:

A1B2C1

(I am then going to select an image to display based on this string.)

What do I do in Counter please? I can't locate what the formula should be - something like Value=xx if Field = xx, but I want to append it each time?

many thanks for any help!

James

[Julio35 · Accepted solution]

Hello, 

I think you have several different ways to do that but i'd set up a formula in the counter column as follows:

CONCATENATE(A,B,C).

[JamesWB]

Thanks, I'll try this.