Lists from Multiple Selections [Table A] to Individual Rows [Table B]

[Hendrik_TnB]

Hi Codans,

I would like to use the button from table “testTemplate” to generate individual rows on “testResult”.

Currently, the button only works by consolidating all values in the one row and single column

Thanks.

[Christiaan_Huizer]

hi @Hendrik_TnB , this post may help you out:

everything is a list, even if all the items live in one cell. They way to ‘speak to each item’ is giving them a (virtual) number using Sequence() so you can reference them one by one using FormulaMap() and Nth().

I guess you can work it out seen your experience with Coda.

Cheers,
Christiaan

Separating Lists into new rows

hx @Aaron_Chupp , I am glad you tried out something. This works: Sequence(1,thisRow.[Line Items].Count()).FormulaMap([Helper Table (Line Items)].AddRow( [Helper Table (Line Items)].[Example-Christiaan],thisRow.[Line Items].Nth(CurrentValue),[Helper Table (Line Items)].[Order Number],thisRow.[Order Number], [Helper Table (Line Items)].TheName,thisRow.Name)) [image] What you see is the application of a virtual index to distribute values living in one cell. Enjoy your day, Christiaan

[Hendrik_TnB]

Hi @Christiaan_Huizer ,

Yup thanks for pointing that out. Your medium post greatly help.