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

Ideas & Features
2

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:

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.

2 Likes