Relation Columns

[David_Saitch_Chelt_Film_Festival]

Hi there

I have set up a coda doc for a film festival.

There is a main page with the list of films available for selection and a Viewing Panel is asked to watch the films then score them and leave a review. This is done via a Coda Form which stores the results in a table for each film in Sub Pages.

I want to bring the average scores for each film back to the main page, so there will be an average score column and on each line it should show the avearge score from the form for that film. I tried using a formula column but that results in the same formula on each row and I effectively want a different formula in each row,

Coda support sugested I link the tables in the sub pages to the main table vie Relation Columns which would allow me to pull the average scores, but I cannot work out how to do that!

Help!!!

[Math_24]

hi,

Need 2 tables :

• Movies
  • Btn for custom url form
  • Average note (star progress or other)
• feedback
  • Movie
  • Note

in form url send movie for auto set.
Set in form (for hidden movie) :

Demo Feedback