
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 31, 2019 04:25 PM
I am trying to combine two fields in a base. Both of these fields are Linked Records. Is there a way to combine the two fields and retain the records. Currently I am getting text if I use CONCENTATE or ‘&’
Here is a demo base with the example https://airtable.com/shr1OM2ygBXu8ygke
Thanks for the help!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 31, 2019 07:48 PM
I’m afraid not. Formulas only work on text, numbers, dates, and (with some limitations) arrays. There’s no way currently to operate on record links other than to extract the text from the primary key, as you’ve seen.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 31, 2019 08:05 PM
Great thanks for the reply. I am thinking now that it might be best to have one table called stakeholders with ‘Internal’ or ‘External’ as a single select. I can create a view for each. That way I can reference Internal or External or both.
Another option I considered was one table that joined the two together but there would be a lot of extra formulas etc. I have added this to the demo base.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 01, 2019 01:02 PM
That sounds like a much better option than using separate tables. :thumbs_up:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 18, 2020 02:21 PM
You actually CAN do this just by converting the join column into a Linked records field again. Airtable will automatically turn “Fred, Susan, Carrier, Barry, Larry” into five linked records.
Caveat is that both the Internal Stakeholders and External Stakeholders have to link to the same table, since the final join column will ask you to select only one table once you convert it to a linked records columns.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2021 02:49 AM
Thanks @TotallyTabular !
This is definitely a solution but is there any way to automate this?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2021 08:03 AM
I’m not sure, sorry. You might be able to whip something up either with the API or Automations, but I have not investigated either one for this use case.
