Help

Re: To-do-list

Solved
Jump to Solution
572 1
cancel
Showing results for 
Search instead for 
Did you mean: 
FundacionFormar
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Mike_AutomaticN
7 - App Architect
7 - App Architect

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

See Solution in Thread

4 Replies 4
Mike_AutomaticN
7 - App Architect
7 - App Architect

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) 

Screenshot 2024-09-04 at 12.08.48 PM.png

Here I set up a "Students" table:

Screenshot 2024-09-04 at 12.07.08 PM.png

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

Screenshot 2024-09-04 at 12.07.58 PM.png

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

Screen Recording 2024-09-04 at 12.06.36 PM.gif

Link to base

thanks a lot!!!

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