Merge multiple user defined confiforms fields

AAN
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 12, 2023

I have 4 user defined text fields in using Confiforms. How do I merge those and add string "-" and show it as a new field.

I try using formula of CONCAT but for whatever reason only 2 fields are only showing.

E.g. 

FieldName = A1

FieldName = A2

FieldName = A3

FieldName = A4

FieldName = MergeA1ToA4

User inputed

A1 as Pass

A2 as That

A3 as Salt

A4 as Please

I want MergeA1toA4 to show Pass-That-Salt-Please

 

I am not sure if merging more than 2 fields is even possible for text?

1 answer

1 accepted

0 votes
Answer accepted
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 13, 2023

Hi @Asther Navarro 

Try chaining the CONCAT functions, as it only takes 2 parameters at the moment

CONCAT(CONCAT(CONCAT("[entry.A1]", "[entry.A2]"), "[entry.A3]"), "[entry.A4]")

Alex

AAN
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 13, 2023

This is perfect @Alex Medved _ConfiForms_ .

I added few more CONCAT to add "-" in betweens as well and its working! Thank you so much!!!

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 13, 2023

You can also do something like

CONCAT(CONCAT(CONCAT("[entry.A1]-", "[entry.A2]-"), "[entry.A3]-"), "[entry.A4]")

Alex 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events