Linked records like Pory.io

This is a great suggestion for a feature in Softr.

Without taking anything away from the need for a feature like this in the future, I think it’s possible you could make something like it in today’s Softr.

Here’s what I’m thinking. Say that in Airtable you have two linked tables, one of Restaurants and one of Menus. And say you want to display the restaurant names along the left side of an inbox, and when a restaurant is selected, you want to show some fields about the restaurant on the right, and then below that a table that displays the menu of the selected restaurant, using the data from the linked record in the Menus table for that restaurant.

Then, in Softr, you could create a hidden page that has a table block on it, and copy the embed code for that table into a field of type Formula in the Restaurants table. In the formula, substitute the record ID* of the embedded menu table block into the embed code, so that the URL of the embed block had the recordId parameter for the menu that the selected restaurant is linked to.

Does this description make sense?

*The one thing I’m not sure about here is how a formula field can get the record ID of a linked record. From a bit of googling, it looks like it would work for the Menus table to have a formula field with the formula RECORD_ID() and then the Restaurants table could have a lookup field with that value in it.

2 Likes