How do I conditionally populate of separate table?

[Don_Moore]

2 tables: Projects & Tasks.
Projects has fields “Project”–Project 1, Project 2, … and “Stage”–A, B, or C.
Tasks has fields “Task”–string, “Owner”–John or Jane, and “Task Stage”–A, B, or C.

Based on matching “Stage” in Projects & Tasks, I would like to populate newly generated assigned task tables, John’s Tasks & Jane’s Tasks, specific to “Owner” in Tasks.

Example: (one record in each table → desired output)
Records:
Projects - “Project” = Project 1; “Stage” = A
Tasks - “Task” = ‘fill out forms’; “Owner” = John; “Task Stage” = A

Output:
“Project”, “Stage”, “Task” should populate a record in John’s Tasks table.
(Project 1, A, ‘fill out forms’)

Can someone help?

[Kamille_Parks]

Don_Moore:

“Project”, “Stage”, “Task” should populate a record in John’s Tasks table.

Does John/Jane need their own tables? Couldn’t you just have two filtered Views in the task Table?

[Don_Moore]

They can be in the same table.
The functionality I’m missing is having tasks populate by Project based on Project Stage.

[Kamille_Parks]

I don’t know what you mean by populate.

You have one table for Projects that links to Tasks. Each task has a field that links to its project and its owner. If you want to see the linked project’s {Stage} then add a Lookup field to the Task table that pulls in that info from the Projects table.

If you mean “when I assign a Project to a particular stage, auto-generate one or more Task records in the Task table” then do something like this:

On2Air | Accomplish Anything with Airtable – 8 Sep 20

How to Automatically Add a Set of Tasks to Each New Project Using Airtable...

With Airtable Automations, you can create an automation to add a checklist set of tasks every time you create a new project. This automation will save you time and monotonous manual data entry.

[Don_Moore]

Thank you, I’ll try this.