![]() Then, add a new field and select the lookup field type. In order to use a lookup field, start by configuring a linked record field. The lookup field requires the use of a linked record to create a link between two tables. How to use the lookup field Add a linked record field Follow along below for more details on how to use the lookup field. This can be helpful for easily accessing information across tables, setting up automations, formulas, and more. In the example below, the assignees for all tasks in a single project are listed in a lookup field. A lookup field can be used to select a field in the linked table and display its values. Each project is linked to a set of tasks.Īs a project manager, you might want to view information about the tasks associated with each project. As an example, let's say you're using Airtable for project management, with projects stored in one table and tasks related to that project stored in another. Introduction Plan availabilityĪ lookup field is most useful when you want to cross-reference information that's stored in separate tables. In other words, the address from the "Clients" table is brought into the "Orders" table. ![]() ![]() Alternatively, 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. You could design a self-linking linked record field in an "Employees" table that could specifically look up an employee's immediate supervisor based upon the dependencies set in the linked record field. As a reminder, linked relationships can be either within the same table or across two separate tables. A lookup field allows you to pull record contents from one linked record into another linked record.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |