Streaming live at 10am (PST)

Collection structure/logic question


#1

I’ve a structuration/logic question regarding a collection.

I’ve a collection called movie.

With:

  • movie name (text)
  • movie url (URL) (from an external website)
  • movie image (image)

So, I can create easily a dynamic page like:

mywebsite/movie/movie-name

On this page I can display:

  • the name of the movie
  • an external redirection to the movie URL
  • the image of the movie

So this structure is simple.

Now, I want to add to this same page other informations:

  • who recommended this movie (name of a person) (text)
  • the comment of this person (text)
  • an external link regarding this comment (from an external website)

One movie can have multiple recommendations.

The goal is to create a page like this one:

mywebsite/movie/movie-name

  • the name of the movie
  • a redirection to the movie URL
  • the image of the movie
  • the name of the person 1 who recommended this movie (text) + his comment (text) + a clickable external link of this comment (url)
  • the name of the person 2 who recommended this movie (text) + his comment (text) + a clickable external link of this comment (url)
  • the name of the person 3 who recommended this movie (text) + his comment (text) + a clickable external link of this comment (url)
  • (it can go until 30 people)

My question is, could you give me the most relevant collection structure I need to create to achieve that result?

Thanks a lot for your help.

Olive


#2

Hi Olive

You need two collections. One for movies and one for reviews / recommendations. In the movies collection create a multi-reference to the reviews. Then in the movies template page you will add collection list in addition to the movie info showing only related reviews.


#3

Ok thanks for your help!

I will try that way:

Review collection:

  • review 1 + name of the reviewer
  • link of the review 1

Because That way I cannot split the review 1 & the name (because of the limitation of 100 fiels)