How to create a column relation from 1 item to Multiple items on another column?

Hi! I’m new to Glide apps and need help to create this:

  1. I’ve a list of Books and a list of Categories.

  2. A Book can have Multiple Categories (PS: the amount of categories must be unlimited, because more will be added in the future).

  3. Then, the Glide App must allow the user to “view” the Book details screen and list all it’s Categories.

Is there a way to do that?

Thanks in advance!

For this you will need 2 sheets. One that lists all of the books and it’s details. The other sheet will need to list the book in one column and a second column for category. Each book’s category will be listed in separate rows. From the Books sheet, create a relation column to link the book in the books sheet to the book in the categories sheet. You can use the relation to add an inline list of categories in the books details.

Thanks for the reply! I’m going to try that!

1 Like