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

Ideas & Features
1

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?

4 Likes
2

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.

3

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
4

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

5

would this ever happen :cry: also is there a similar request for removal of items from lists?

1 Like
6

Chiming in to give our use case, which is also related to the email integration. We want to use the integration to connect all emails to contacts in our CRM in one overview, but currently we can only show From, To and CC in separate collections. If we can have a combined field (from a formula) we can have much clearer views in our CRM. We for example also want to show all emails of all contacts within one client organisations, but since these are 3 lookup-fields that’s not going to work either.