Bring text from a column in one table to another table, each in a new row

[JEC_Aviation]

Hi!

Does anyone know how to take the information that is in another table and have it automatically be in a new row for each of the items?

In this example… I need the information from “1” to “2”… but each text in a new row.

Thanks

[Christiaan_Huizer]

goodmorning @JEC_Aviation

would you try this in your button?

Sequence(1,thisrow.Registrados.Count()).ForEach(
  [Listado alumnos participantes].AddRow(
    [Nombre completo],thisrow.Registrados.Nth(CurrentValue)
  )
)

Cheers, Christiaan

[JEC_Aviation]

Good morning Christiann! thanks for writing back again

I did not have a button but I assume I had to create a new one, but I do not know if I am doing it correctly, do you know what is wrong?

[Christiaan_Huizer]

@JEC_Aviation , I guess what is happening:

the ) underlined in blue must be removed
the Nombre completo underlined must be Currentvalue

this currentvalue is in your set up not accessible, because you closed the ForEach too early.

and the end should have 3 times ) you have two in your actual set up

you can read here a bit more about how this works:

How to add a row in Coda?

[JEC_Aviation]

It worked! thanks Christian

Now just have to add an automation so that every time a new person is added to the list to automatically appear in the other table.