Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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




1 answer

1 accepted

2 votes
Answer accepted

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: 



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


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?

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

for example, right after the [entry.KeyPart1]

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

perfect! thanks.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

389 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you