Confiforms formula to combine multi-user field values

[Joanne Succari]

I have 2 fields in my form:  users1 and users2

Both fields are not required

I want to create a separate formula field "approvers" in the same form and want to combine users1 and users2 to create a list of usernames

Eventually, I would like to leverage the resulting list of approvers in the "edit" configuration of another form as "entry.approvers.asList"

Is there a function (or functions to chain together) that combines the values of 2 multi-users fields before I transform the result to a comma-separated list?

@Alex Medved _ConfiForms_ 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

There is no magic formula to use and you need to combine a few operators to achieve the desired result - https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions 

You can use formula like below to concatenate non-compulsory multi-user fields together

CONCAT("[entry.users1.asList]", IF(EMPTY("[entry.users1]"), "[entry.users2.asList]", IF(EMPTY("[entry.users2]"), "", ", [entry.users2.asList]")))

Alex