Skip to main content

Hello, dear community. I hope you can help me solve this issue I need to address:

I have a table with a list of students and another table with a list of tasks, each with a corresponding status column. I need to create a task list where each student can update the status of each task.

The status should not be mixed with the statuses of other students, but rather each student should be able to mark their own status for each task.

Hey! This is pretty straightforward. Rather than having one Task record, which is linked to all students, you want to have one Task record for each individual Student (one to one relationship between Task and Student). 
In such way, each Student will be able to handle their own status for a given task.

e.g. 
Task: Write an essay | Student: John | Status: Pending
Task:  Write an essay | Student: Maria | Status: Done

Mike, Consultant @ Automatic Nation

Try using an automation with a repeating group action to help with this (https://support.airtable.com/docs/repeating-groups-of-automation-actions) 

Here I set up a "Students" table:

And a "Task List" table where I trigger the automation via a checkbox:

And the automation will create one record per student in the "Tasks" table so that you can update each record individually:

 

Link to base

Hey! This is pretty straightforward. Rather than having one Task record, which is linked to all students, you want to have one Task record for each individual Student (one to one relationship between Task and Student). 
In such way, each Student will be able to handle their own status for a given task.

e.g. 
Task: Write an essay | Student: John | Status: Pending
Task:  Write an essay | Student: Maria | Status: Done

Mike, Consultant @ Automatic Nation


thanks a lot!!!

Try using an automation with a repeating group action to help with this (https://support.airtable.com/docs/repeating-groups-of-automation-actions) 

Here I set up a "Students" table:

And a "Task List" table where I trigger the automation via a checkbox:

And the automation will create one record per student in the "Tasks" table so that you can update each record individually:

 

Link to base


thanks a lot!!! very helpfull!!!!

Reply


Terms & Conditions