Collection structure/logic question

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

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.

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)

1 Like

To achieve the desired structure, you can create a ‘Movie Recommendations’ collection with the following fields:

  1. Movie Name (text)
  2. Movie URL (URL) - External website link
  3. Movie Image (image)
  4. Recommendations (repeater field):
  • Name of the person (text)
  • Comment (text)
  • External link of the comment (URL)

This way, you can easily display multiple recommendations for each movie on the same page while maintaining a structured and organized collection. In My case i just simply wrote a blog post just like movies similar to My fault.