So I am trying to do something I’m not really sure how to make, but then again, I know what I need to obtain and I am really confused about what I’m getting :))
So in a task management app, the Structure of the app is as follows:
- A Project has many Objects
- An Object has many Tasks
- A Task has many Times
A Time is the Time spent by a User on a certain Task. So the Users Complete Times to Tasks as they Work on that Task (in order to produce an Object which is part of a Project).
So the Total of Times spent on Completing Tasks will at the end, amount to represent the Workmanship spent on that Project.
Now I would like to add the possibility to add, when completing a Time (through a Form), the Materials Used while working on the Task. So I just simply create a LongText Column in the Times Table, where Users, as they fill in the Time, also add in LongText the Materials they used (plywood, laquer etc.)
So far so good.
A Task has Many Times. And of course, since the Users fill in the Materials they used through Times, I would like to be able to see in the Task, all the Materials used for that Task. So I made a Virtual Column with this Formula:
[Related Times][Time - Used Materials]
and in the detail view, I get the Materials filled in the different Times, separated by a comma.
1. First question - is there a way to get these different Materials filled in at different Times, separated by a new row? So that the next Material from a different Time is displayed in the next line?
But now the weird part, where I get completely lost, is when of course, I would like to see also, all the Materials used in an Object. So I make another Virtual Column in the Object Table and put in the Formula:
[Related Tasks][Task - Materials Used]
and this one is like this:
Now you can imagine, I would like to have also all the Materials displayed for a Project.
Any advice here?
What I would like to get is that in a detailed View of a Task/Object/Project, have a list of all the Materials which are filled in by the Users, every time they fill in the Form of a Time Related to these Tasks/Objects/Projects, like this:
- 2 sheets of plywood
- 1 l of laquer
- 4 hinges
- 4 sheets of plywood
Thank you, and sorry for the long story, but I’m in the blind here and I’m not sure how to put it clearly AND shortly.