Link to table field

Baserow’s Link to table field is a feature for creating relationships between tables and organizing your data in Baserow.

Overview

The Link to table field is useful for connecting one row in a table to another row in a different table. This can be helpful when you have related data that you want to keep organized and connected.

For example, let’s say you have a database of customers and a database of orders. You could use the Link to table field in the orders table to link each order to the customer who placed it. This would allow you to easily view all orders placed by a particular customer, or view all customers who have placed orders.

Note that a Link to table field cannot be the primary field of a table.

Connecting data across tables with linked rows

enter image description here

You can establish connections between tables using the link to table field in Baserow. By linking rows in these tables, you can capture the dynamic relationships between them.

When you begin to build relationships between data in your tables, it’s important to have defined the structure of your data beforehand. This is especially useful if you have many tables containing related data. For example, if you have a table of applicants and a table of roles, you can use a Link to table field to link each applicant to what role will be interviewing for.

To sort by a Link to table field in Baserow, you can create a Lookup field that references the Link to table field, and then sort the rows based on the Lookup field. This allows you to easily organize and arrange your data in the desired order.

You can create links between related rows in a link to table field to represent the relationships between them.

Linked rows allow you to create relationships between your data to minimize redundant rows while ensuring they are available where you need them.

  1. In either related table, create a link to table field to connect both tables by clicking on the +.

    enter image description here

  2. Click on the dropdown under ‘Select a table to link to’. This will display the linked tables for you to choose from. Individual rows can be linked to one another to establish a relationship between them. You can link two different tables together, and also link to the same table. To create a link that references rows in its own table, you need to create a link to table field and choose the same table as its source.

    enter image description here

  3. Click the Plus + button inside a cell in a grid view to open the linked row picker.

    enter image description here

  4. When viewing from an enlarged view, click the + Add another link button to open the linked table rows, you’ll see a list of rows that you can link to.

    enter image description here

  5. If the linked table contains more than 10 rows, you can use the navigation arrows to see all of the rows or search the list to find the desired rows more quickly.

    enter image description here

Once you have added the link to table field, every time you connect two tables using the link to table field, you can see linked information in each table so you’ll know which items are connected to each other. The list of linked rows can have more than one rows selected, one at a time.

Create a new row from the row select modal

You can create a new row directly from the row select modal. To do this, click the + button while choosing a relationship in the link to table field.

enter image description here

To unlink a row, select a cell in a link to table field, then click the X on the connected row you wish to unlink.

enter image description here

Enlarge a linked row

If you click on a linked row within a link to table field, an enlarged version of the row being linked to will open.

enter image description here

When you click on a linked row within an enlarged row, it will open a new enlarged row above the existing one.

enter image description here

You can create a linked row from an existing field using the field customization option. However note that this will delete the values in your existing field, and you will be able to link rows for each value.

Make sure to copy and paste the data into a new field before converting any fields. Next, choose the Edit field option from the field customization menu. Select Link to table field, then select the table you want to link rows from.

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.