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?
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
This is perfect @Alex Medved _ConfiForms_ .
I added few more CONCAT to add "-" in betweens as well and its working! Thank you so much!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can also do something like
CONCAT(CONCAT(CONCAT("[entry.A1]-", "[entry.A2]-"), "[entry.A3]-"), "[entry.A4]")
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.