I’m trying to simply show the aggregation of two lookup fields into a third column while keeping the linked values.
Concatenate will de-link the data as it only works with text values- how do I carry the link through concatenate? Is there a formula or AirTable workaround that will join data without losing the links?
Welcome to Airtable Community !
You have 2 scenarios here:
Are both values linked to the same Table?
Are both values linked to different tables?
I assume it is the latter?
In this case a work around would be to do the following:
In the table where you want to Link to, you will create 2 new Fields (or one for each record you want to concatenate), Lookup the new field you did in the other Tables.
In a final Concatenate field, concatenate both URLs. Now you have the records that are linked to this record in URL forms.
It’s a work around but it might help.