Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
Self-hosted
What do you need help with?
I am trying several table apps recently, one of the essential features I am looking for is to embedded the data of other table to the current one. For example, with Grist this can be done by create another table widget, which I can view and edit data directly.
I am wondering if this can be done in Baserow? As we want to create a data model for experiments, so we need to such feature for research to add recipe, steps, etc.
Please attach screenshots or videos if they help illustrate your question.
I think what you’re aasking about is what makes relational databases (such as Baserow) much more powerful when compared to spreadsheets. This type of “embedding” as you refer to is known as relationships within a database and this is a native and core feature of Baserow (and other databases).
In Baserow, you can achieve this through relational fields and views. Here’s how to set it up:
1. Create Link Fields
In your People table, add a “Link to another table” field that connects to your Rates table
This creates teh relationship between people and their rates
2. Use Lookup Fields
Add lookup fields in your People table to pull specific data from the linked Rates table
You can display rate information, roles, dates, etc. directly in the People view
3. Set Up Views with Filters
Create filtered views in your Rates table that show only relevant data
Use these views as the basis for what gets displayed in your People table
I have tried Link Fields and Lookup Fields, the problem is Lookup Fields cannot show reference data as an editable table. Or can you please share a screenshot of doing the same thing in Baserow?
Perhaps I am not fully understand your requirements. Is it that you want all the data (including linked/related data) to all be editable wihtin a single table? Because that is not possible within Baserow, you would need to click the record to open the details modal of that record and then update the records’ information.