"Union" function to merge multiple collections into a single collections field

I’ve seen this pop in many different threads but don’t think there’s an official feature request for it.

I’d basically like the same functionality of “Join()” only it returns a collection of entities instead of a text field.

Here’s the “Get Help” thread with the most conversation around the need for this feature: How to union two list fields in the same Database?

With the updates to the email integration I have started importing email to Fibery. However, some contacts use multiple email addresses.
I would use a join formula to join all the emails linked to a single contacts many email addresses.

I ran into a usage case where I also wish to combine multiple different collections (look ups) into one field. Is this possible? Using formula appear to be not possible.

1 Like

It is not yet possible with formulas, but can be somewhat covered with automations.