Display data from two linked tables in a single softr table block

Ask the community
1

Hello, my softr app is a project management tool for video editing projects. I need a better, more automated way of understanding where each project is in its lifecycle

My data source (airtable) has two tables, the first is a table containing all the data about a project then second table contains information about each draft video created for a project, and this table it linked to the master projects table.

In my softr app, I have a table the displays all the projects we are working on with each project populating a row in the table. In a perfect world I would like a column of that table to tell where what was the last “thing” done in the project. In reality that ask may be too big, so instead I would settle for at least knowing the name of the most recent draft video posted to a project.

I am assuming there is no way to pull data from two table into a single block, so my next guess is that I would need a field in the projects table that has some logic and can populate itself which information gleaned from the drafts table? And once that data is in the projects data source, I can present it in the softr table block?

So the question I guess is what kind of logic would I need to apply to the airtable so that the row gets updated when a new row is added to the drafts table?

Thanks in advance

2

Unless I’m missing something, aren’t you just talking about a lookup field in your Airtable (table). You have already linked the tables so you can see the primary field in your linked table in the list of items fields (in the content section of the table). In Airtable you right-click on the Linked field in the table you’re using as the source and choose ‘add lookup fields’. Now you can display fields from both tables in the table block.