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?
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]")))
Phew, Atlassian Team 2021 blew by. With dozens of demos and a handful of keynotes, you may have missed some of the awesome Confluence Cloud sessions. Don't' worry, you can watch them all here or on Y...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events