Aug 03, 2021 09:15 AM
Hey community!
So i want to add recurrent tasks for every record, the tasks are the same for every record. I tried doing a separate table named tasks with a subtask column and i link it to my primary table. THE PROBLEM is that when lets say record one fill his tasks, the tasks keep filled for ALL the records, i want to fill them individually for each record.
Any suggestions?
Aug 03, 2021 09:32 AM
You’ll need to setup your table structure differently. You’ll need to create another table to create a many-to-many relationship:
Aug 03, 2021 10:00 AM
Thanks for your reply Scott!
I read the article but couldn´t find how can this help me,
i forgot to mention that what i want to do is have a check list of the same 3 tasks for every record. So imagine
Name Tasks
Mario Starting task (in check list form)
Scott Starting task (same task but empty check list)
Aug 03, 2021 10:05 AM
Technically, you probably don’t even need 3 tables. But with a multiple table approach (whether it’s 2 tables or 3 tables), you would end up needing 3 linked task records for each master record.
However, if you only need 3 tasks for each record, you might just want to create 3 checkbox fields that you use for each record.
Aug 03, 2021 10:09 AM
The check box is an excellent idea!
However, every task has 3-4 sub tasks so, the check box will be of 10 items, ill try that and see how it looks.