Greetings to all,
I'm looking for an efficient solution to a problem concerning the organization of my to-do list for different events during the year.
We've drawn up a list of tasks (110) to be repeated at each event.
I'm facing 2 issues:
1 - When I create a list view, I link the tasks with the event; the task remains a single record, so if I validate a task for an event, the task will be validated for ALL events. It doesn't matter what the hierarchy of my list is (or did I misunderstand?).
2 - In a previous version with 89 tasks, I was able to get around this issue with record templates. When we decided to take part in an event, the 89 records were created, and then I pressed a button to launch several automations linking the new records to the congress. Not the most refined method, but it worked very well. Problem: record templates are limited to 100 records per base.
I'd like to avoid recreating a table for each event to keep a clean AirTable base. If possible, have one event table, one task table. If necessary, a 3rd table to join the previous two.
I'd like to automate the creation of the to-do list and avoid making crude copy-pastes for each event.
Edit: Each spot has a different deadline depending on the date of the event. So I can't reduce my task list with long text and checkboxes.
Do you have any ideas to help me?
Thank you in advance for your feedback and your time