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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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