How do I concat and substringbefore expression in calculated data field

Caitlin Brown

using on prem confluence, confiform version 3.13.8

I wish to concatenate 2 data fields, the ChallengeTheme field is a dropdown field with value example "1. Collaboration" and second field RiskID is an autonumber field 

 

If RiskID is "31" and Challenge Theme is "1 Collaboration"  I want the concatenated field to populate as 1.31

I have done the following expression:

concat(substringBefore([entry.ChallengeTheme], '.'), '.', [entry.MBDARiskID]) however it is not working and the value shown once record is submitted is .1

 

 

Alex Medved _ConfiForms_

Hi

Where do you want to concatenate the value? In some formula field or just online, in the view?

1. CONCAT("[entry.ChallengeTheme].", "[entry.MBDARiskID]")
2. Right in the ConfiForms Field macro's field name parameter: ChallengeTheme.append(.[entry.MBDARiskID])

Alex