Hello, please, I develop database in which I have one document - “ToDo”. I need to assign name for responsible person and main deadline. At the same time I need to specify more partial deadlines and responsible persons, who cooperate in the same task.
Then I need one view in which every user can see his tasks which he is responsible for, and tasks which he cooperates in (both cases together). I would like to have all information in one document.
Please, could you give me an idea of the easiest solution of this problem?
(I wanted to have fields for name of responsible person and main deadline, and then multivalue field for other deadlines and another multivalue field for cooperators but there is a lot of problems which I can not solve). Thank you, Jakub
From my experience, I’d venture to say your proposed solution is not the best way to do it.
Whereas if you have only one multi-value field (like dates) it is easy and straight-forward to do, I have my doubts about a 2 dimensional array. If it is possible to do it will be rather complex and you will have issues with what to show in a view - you cannot show text in a column that would be dependent on the category the document appears in (as far as I know).
Best bet is to create a main job document and from there create ‘sub documents’ attached to the main jobs, each carrying the information of the sub-task/partial deadline. An integrated view will enable you to show all sub-documents inside the main document.
The partial tasks can then appear individually in the necessary views and a little bit of code can enable you to open the main task from within the sub-task.
We’ve done that with an industrial-strength tasks module, so I am positive this works.