+4Hello, 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.
Best answer by Mike_AutomaticN
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
+28Hey! 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
+31Try 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:
+4Hey! 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!!!
+4Try 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:
thanks a lot!!! very helpfull!!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.