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”.
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