Peer Book Review & Rating
Hello,
In our business we read a lot of books and share the knowledge among ourselves. Therefore I am developing a "Peer Book Review" sheet whereby any employee can look up a book title and add their personal review comments and rating. If the book is not on the list already, they simply add it as a new book.
I created a sheet where the book title is the parent row, and the reviews are the child rows, but it seems like a clumsy data structure, and the number of reviews will vary by book so the user would have to add a child row everytime.
Is there a template for this already? I looked and couldn't seem to find anything similar.
Any help is appreciated. Thanks.
Answers
-
Instead of using parent children hierarchy's, use a report and group by book name. So every time someone fills out a form/review they add a new row, in the form there is a dropdown to select a book to review, or if you don't have the dropdown restricted they could also enter the title of a new book. You would have to update the dropdown though for future reviews of new books.
In the report if you group by book title it will keep all the reviews in their respective drop downs similar to parent child hierarchy.
**If you have "Advance" or data shuttle I believe you could use data shuttle to auto update the dropdowns.
-
Thanks Samuel - that's a great suggestion - much appreciated!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives