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.
While it isn't possible to change the comma separator to another symbol, you can use a rollup field instead of a lookup to do so.
For this approach, add and configure a rollup field similar to the lookup field instructions above. Then, in the rollup aggregation formula, paste the following:
SUBSTITUTE(ARRAYJOIN(values), ",", " + ").This instructs the rollup field to substitute the comma separator with something like the
+ sign instead. You can switch out the
+ sign in this formula with any symbol you'd like to use as a separator.