I have been banging my head against the wall for a day trying to figure this out but I am really struggling. Perhaps I am just too close to it and aren’t able to see clearly. I am sure I did things like this in the past with ease.
Here’s a copy of my spreadsheet without the real users’ data.
My app is structured in the following way.
There’s a reading list Tab where users can add books.
To each book, they can add notes
There’s a Books tab that is a copy of some entries on the Reading list but removing any duplicates.
What I am trying to achieve is that users come to the books tab > learn about the book and see that other users have written notes about that book > click on a users name and see a list of the notes that user has written on the book only > click on a specific note and read it.
I’ve tried many ways, right now what is happening is that both Nugget Notes user and Laura are displaying the same results despite the notes being from Nugget notes only