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.
PrimaryKey - Set by rule
KeyPart1 - set by user
KeyPart2 - set by user
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
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 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