As far as I can see, I am not able to manipulate and output Collections in formulae. They seem to always have to be converted into strings with a Join() function? I would like to calculate connections through a formula rather than an Automation: So I am modelling my component library in Fibery. It …

Thanks @Chr1sG , yes, hadn’t found that thread. Added my comment there.

Create and Manipulate Collection in Formula

Chr1sG October 11, 2023, 7:50am 2

It sounds like you would like a ‘union’ function, for combining collections. It’s not yet possible, but we have the feature in the backlog

Topic		Replies	Views
"Union" function to merge multiple collections into a single collections field Ideas & Features formulas	6	385	April 21, 2026
Allow Formulas to return a collection of just a specific field from Filter results Ideas & Features	3	203	October 22, 2025
How to union two list fields in the same Database? Get Help formulas	38	1922	October 11, 2023
Use collection in if formula Get Help	4	305	July 10, 2023
[Logic] Formulas - Chained/Multi-Hop *-to-Many Relation Fields with Distinct() Function Ideas & Features formulas	6	45	April 16, 2026