# Combine multiple relation fields into one views cell as clickable entities (no polymorphism)

**URL:** <https://community.fibery.io/t/combine-multiple-relation-fields-into-one-views-cell-as-clickable-entities-no-polymorphism/5765>\
**Category:** Ideas & Features\
**Created:** [January 28, 2024, 7:47pm UTC](https://community.fibery.io/t/combine-multiple-relation-fields-into-one-views-cell-as-clickable-entities-no-polymorphism/5765 "2024-01-28T19:47:49Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [January 29, 2024, 3:30am UTC](https://community.fibery.io/t/combine-multiple-relation-fields-into-one-views-cell-as-clickable-entities-no-polymorphism/5765/2 "2024-01-29T03:30:34Z")

</div>

If all the fields are named the same (“Conversion Log”, in your example) then they should all be shown in the same column already.

If they’re all named different things, then you can use a formula with a bunch of If statements to display whichever relationship is has been populated, or you can use the “Join” function.

Using Ifs:

```auto
If(IsEmpty(ColumnA),
    If(IsEmpty(ColumnB),
        If(IsEmpty(ColumnC),
            ColumnD, ColumnC)
        ColumnC),
    ColumnB)

```

Using Join:

`ColumnA.join(Name, ", ") + ColumnB.join(Name, ", ") + ColumnC.join(Name, ", ") + ColumnD.join(Name, ", ")`

Best case scenario would be a [Union function if it ever gets built.](https://community.fibery.io/t/union-function-to-merge-multiple-collections-into-a-single-collections-field/5680)

---

_[View the full topic](https://community.fibery.io/t/combine-multiple-relation-fields-into-one-views-cell-as-clickable-entities-no-polymorphism/5765)._