A lookup field allows you to look up a specific field in a linked record.
For example, if you have an Orders table with a field linking to Clients, you could create a lookup field that displays the linked client's address.
Lookup configuration is pretty straightforward. First, you pick the field with the linked records you want to look up. Then, you pick the cell on those linked records that you want to display.
Adding multiple lookup fields in bulk
You can easily add multiple lookup fields by right clicking on the name of your linked record field. Then, click the menu option to Add lookup fields.
This will bring up another menu where you can select specific fields from the linked table to add as lookup fields.
Note that if there are multiple linked records, the lookup will concatenate the cell values and separate them with a comma.