Hi there, I’m a beginner and I’m designing my first doc, but now I’m stuck trying to understand how multiple selections work for Coda.
I have a table (let’s call it Data) that in a column (Workers) looks up to another table with the multiple selection actived. For every data entry / row, I select one or more workers to work on it.
I want to generate another table (Workflow) with a row for every pair data/worker.
So, for example, if I have the data X in the first row and the workers John and Paul, in the new table I need:
Row 1: X in column “data” and John in column “worker”
Row 2: X in column “data” and Paul in column “worker”
And so on with the other rows.
In short, I need to convert those multiple selections from one cell to individual rows. For Coda, however, those workers are considered part of a unique cell. Any idea how to workaround?
PS: is it possible that those individual rows generate themselves from time to time or with some button? I’ve found this closed topic: Lists from Multiple Selections [Table A] to Individual Rows [Table B] but I’m struggling to understand how to do what they suggested there.
Thank you in advance.