How do I set a Confiform Field value to the value of 2 other fields

[Erin Smith]

I have a field in my Confiform that is set as the Primary Key in my database. The primary key is made up of the values of 2 of the fields on my form.

But when I use a Confiform rule to set the value of the Primary Key it only sets the value as the first field.

My Fields:

PrimaryKey - Set by rule

KeyPart1 - set by user

KeyPart2 - set by user

Rule:

PrimaryKey=[entry.KeyPart1][entry.KeyPart2]

[Tim Oldendorf · Accepted solution]

This might work for you:

Change the PrimaryKey field type in the definition to be a formula field type. And then use a formula to concatenate the values together.

For example: in the formula enter this: 

CONCAT("[entry.KeyPart1]","[entry.KeyPart2]")

So then if KeyPart1 = Hello and KeyPart2 = World when the user submits the form it should give PrimaryKey a value of HelloWorld

[ita bellablu]

The example above HelloWorld has no space between two field values. How is a space added to get a space or dash between the two field values, to Hello World?

[Alex Medved _ConfiForms_]

Just put the space where you need that... as easy as that

for example, right after the [entry.KeyPart1]

CONCAT("[entry.KeyPart1] ","[entry.KeyPart2]")

[ita bellablu]

perfect! thanks.