The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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]
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just put the space where you need that... as easy as that
for example, right after the [entry.KeyPart1]
CONCAT("[entry.KeyPart1] ","[entry.KeyPart2]")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.