You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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
Just put the space where you need that... as easy as that
for example, right after the [entry.KeyPart1]
what about using this in a filter within tableview for example, fy:CONCAT("FY","([entry._now.jiraDate().split(-).get(0).trimLeft(2)]+1)")
the second part is evaluating current year, the second part works perfectly on its own but I want to add FY on the left side. Please help, thanks
or... make this easier