Once you link tables in Tabidoo, the linked field will display in the form of your table. You can afterwards select from the lookup which records from the source table will display in grid.

The lookup after linking tables in Tabidoo

However, sometimes the linked table contains too much unnecessary data which you won't even use in your current table. Therefore, in this chapter will be explained how to display only some records in the lookup.

1) How to define which columns will display in the lookup

Let's imagine we want to display only column/field "Name" in the example before (see picture - The lookup in Tabidoo).

How to achieve it?

1) Go to the field settings in the source table

2) Open the fields which you want to display in the lookup

3) In the advances features select the option "Show in the lookup"

What will happen now?

Now only the selected field (e.g. Name) will display in the lookup (see example below).

The lookup in Tabidoo

2) How to filter records in the lookup

Let's imagine you want to filter records in the lookup and display only selected names in the example before.

How to achieve it?

1) In the table we go to the settings of the linked field. In this case, the field "Owner"

2) In the advanced features we click on + Add field for filter

How to filter data in the lookup in Tabidoo

3) We define by which field the records in the lookup will be filtered.

3) How to define which data will display in the record description after selecting a value in the lookup

We want to setup the following:

Name and Position in the record description

After selecting a value from from the lookup, we want the Name and the Position to be displayed in the record description.

How to achieve it?

1) Go to the field settings in the source table

2) Open the fields which you want to display in the box

3) In the advances features select the option "Show in the record description"

The option "Show in the record description" in the advanced features