Is it possible to associate two fields together, so that if one is inputted into table, 2nd field will autopopulate in the same row?
I’m trying to set up a 3 level todo list as this: Category -> Subcategory -> Task, where for single Category there may be multiple children subcategories:
- Health - Physical Activity - Go for a run
- Health - Diet - Eat breakfast
- Health - Rest - Get 7h of sleep
Anytime I’m adding a new task to one off ‘health’ subcategories i would like that task to automatically get labeled with ‘Health’ category to avoid doing it manually every time. I have only handful of categories and subcategories to which I add all my daily task so would be great to automatize it a bit.
Currently I have a todo table with a lookup columns for category and subcategory received from another table but for each task I need to manually select category and subcategory.
I hope I was able to explain properly what I’m trying to achieve.
Thanks a mill!