Combining record links to another table within the current one

Hi there,

I have table named “Groups” which contains fields about a Group Therapy Session along with two Lookup columns to another table called “Session Master” which contains the materials(i.e. books) used for the session in the group.

Now, in the Session Master table the fields to which the Group’s lookup columns are pointing to are named “Pre-Session Materials” & “Post-Session Assets” respectively. Those two are actually links to multiple records of another table named “Content Library”.

pic3

What i want to do is to find all the Records from both the Pre-Session Materials & Post-Session Assets and combine them into one column within the Groups table. Is that possible?

I have this formula already which just joins the contents of both of these as a string array but i need them to be record links so that i can show them in stacker as interactable content. The formula is the “All Session Materials” column in the Groups table and its formula is ARRAYJOIN({Materials from Sessions} , {Post-Session Materials from Sessions}).

P.S. I’m pretty new to Airtable so please bare with me :slight_smile:

This is a known limitation that I’d like to see change too. As for the formula bit, seems you’ve already discovered, they convert to strings rather than maintaining the lovely linked record functionality. There isn’t a current way to convert a string to a linked record object, or even generate hyperlinks.

Workaround

One thing you could look into would be generating URL links instead. They’d be long links, so it’ll look a little messy - particularly when multiple are listed. I forget the specifics but each Airtable URL is something like airtable.com/tableID/viewID/RecordID. It’d look something like this when you’re done:

If you use rollups, I recommend using a formula that joins with linebreaks to keep the links separated. Something like ARRAYJOIN(values,"\n\n"). FYI, it’s SHIFT + Space to expand cells into a modal as pictured. Best of luck!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.