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!)
