Hi there @Giuseppe_Birardi ! Welcome to Coda and to the Community !
It is doable but depending where you want to put your desired output, it might require some adjustments .
So, in the sample below, I’ve kind of reproduce your screenshot and to get your desired results, in the table Subtasks
I’ve created the Reference
fields [Tasks]
and [Activity Owner]
both of which just show those info you’ve entered in your Tasks
table .
(Sorry, I’m enable to find another way to say this )
Now, on the canvas of my sample, you’ll see 3 very similar canvas formulas .
They do the same thing but one keep the reference to your [Activity Owner]
, [Tasks]
and [Subtasks]
and the other don’t and the last one creates a Bulleted List
.
The formulas looks like this :
Subtasks.FormulaMap(Format("{1} in {2} will take care of {3}",CurrentValue.[Activity Owner],CurrentValue.Tasks,CurrentValue)).Join(Character(10))
Put into words, it kind of says :
For each subtasks (FormulaMap()) in the Subtasks
table (each specific Subtask
is represented by CurrentValue
), follow this text pattern (Format()) and then, join them (Join()) using a Character(10)
(Character()).
Character n°10
in Unicode is the one for a line feed/Newline (so each Subtasks
the formula uses begins with a newline, otherwise, the text is just displayed inline in the formula on the canvas )
And concerning the Format()
formula, here :
-
{1}
= CurrentValue.[Activity Owner]
(the owner of this specific Subtask
in the list of all Subtasks
)
-
{2}
= CurrentValue.Tasks
(the Task
linked to that specific Subtask
in the list of all Subtasks
)
-
{3}
= CurrentValue
(the specific Subtask
in the list of all Subtasks
)
The list of all Subtasks
being the Subtasks
table .
And just in case, if you need more info about FormulaMap()
, take a look at this topic here . It helped me a lot with this specific formula !