I have two tables in Coda. The first one is called ‘Adoptions Data’. It has columns ’ Jurisdiction’, ‘Cycle’ and more.
Jurisdiction | Cycle |
Alaska | blank |
Alabama | blank |
The second table is called ‘Code books’. It has columns ‘Jurisdiction’ and ‘Effective Dates’
Jurisdiction | Effective Dates |
Alaska | 09/12/23 |
Alaska | 09/5/21 |
Alabama | 10/12/22 |
I want to update/format the column ‘Cycle’ using a formula, to include a list of all effective dates with the same Jurisdiction from the table ‘Code Books’. I tried using the formula below, but it doesn’t return anything.
[Code books].Filter([Code books].Jurisdiction=thisRow.Jurisdiction).[Effective Date].List()
How should I write my formula ?