Link to Table Field

Managing a project can be a complex task, with many moving parts and details to manage. It is clarifying to keep track of the many connections between projects, clients, and team members, but it can be challenging to remember who is working on what and where everyone is in the process. To be productive, it is important to track the status more effectively. Note that a link to table field can not 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. You can create links between related rows in a link to table field to represent the relationships between them. 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.

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

  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 now 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

Enlarging 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

If you click on a linked row within an enlarged row, a new enlarged row will open on top of the already enlarged row.

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.

If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!