Sep 03, 2024 08:17 AM
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.
Solved! Go to Solution.
Sep 03, 2024 04:17 PM
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
Sep 03, 2024 04:17 PM
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
Sep 03, 2024 09:09 PM
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:
Sep 04, 2024 09:46 AM
thanks a lot!!!
Sep 04, 2024 09:46 AM
thanks a lot!!! very helpfull!!!!