Day 3 - Hours 5-6

Hour 5-6: Advanced Field Customization

Using lookup, rollup, and formula fields:

Explain the concept of lookup fields in Airtable, which allow users to retrieve data from another table based on a specific relationship

Describe rollup fields, which summarize data from a related table using a specific aggregation function (e.g., SUM, AVERAGE, COUNT)

Reiterate the use of formula fields, covered in the previous session, to perform calculations and transformations on data within a table

Provide examples of how each field type can be used in different scenarios

Conditional logic in Airtable fields:

Introduce conditional logic in Airtable, which allows users to create rules that determine the display or calculation of data based on specific conditions

Explain how conditional logic can be used in various field types, such as lookup fields, rollup fields, and formula fields

Give examples of how to use conditional logic in different situations, such as displaying a specific value based on a certain condition or calculating a value only when specific criteria are met

Hands-on exercise: Customizing fields using advanced features:

Ask students to return to the table created earlier, containing tasks and their related information

Instruct students to create a new table to track project milestones and their associated tasks

Guide students through creating a lookup field to display the related tasks for each milestone

Next, demonstrate how to create a rollup field that calculates the total duration of all tasks within each milestone

Finally, encourage students to create a formula field that uses conditional logic to display the status of each milestone (e.g., "On Track" if all tasks are completed, "In Progress" if some tasks are completed, or "Not Started" if no tasks are completed)

By the end of this session, students should have a deeper understanding of advanced field customization in Airtable, including the use of lookup, rollup, and formula fields, as well as conditional logic. They will also have gained practical experience in applying these concepts through hands-on exercises.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.