Merge multiple user defined confiforms fields

[AAN]

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?

[Alex Medved _ConfiForms_ · Accepted solution]

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]

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_]

You can also do something like

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

Alex