The community member is trying to create a system where Table 1 contains a list of blog posts, and Table 2 uses a "link to table" array column to list specific blog posts from Table 1. They want to display Table 2's array of selected items from Table 1 in Webstudio, but the array only provides limited data.
The community members discuss a solution using Baserow's "join" parameter to pull in fields from the linked table. The idea is to use the first field from the main table where the link is made, and the second or third field from the lookup IDs in the sub table (not the main table IDs).
This solution, while not explicitly marked as the answer, seems to have worked for the community members after some trial and error.
Hi! Here's what I'm trying to create: Table 1 is a list of blog posts. Table 2 uses a "link to table" array column to list specific blog posts on each row. In Webstudio, I have a Collection to display Table 2's array of selected items from Table 1. Like manually selected related posts.
Problem is, Baserow's array only gives a little bit of data. I can use a few Lookup fields in Baserow to get one piece of that data each, but then I have multiple collections of disassociated data. So I tried to use a formula to combine them, but the results weren't selectable in the WS expression editor. Then I tried to make the Collection list the slugs and make a Resource for each item, but I couldn't select the Collection's data.
How should this be done in WS? There are a lot of other use cases where this would be needed, so the question is more conceptual.
Yes this took me a while to figure out as well, but indeed the join parameter does the trick.
The idea is that the first field comes from the main table where you're linking to the sub table. And the second or 3rd field are the IDs from the lookups in the sub table (not the IDs from the main table!)
