# Is it possible to allow users to 'review' or comment on a collection item? **URL:** \ **Category:** Ask for Help\ **Created:** [January 6, 2023, 5:26pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419 "2023-01-06T17:26:14Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)\ **Post date:** [January 6, 2023, 5:26pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/1 "2023-01-06T17:26:14Z")
This may be a weird request, but I have a collection of companies and I want my users to be able to share comments/thoughts/experiences with other users and maybe even give a star rating. Do you know if this would be possible? I love this tool so much, and thanks to all the experts for their help thus far . ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 7, 2023, 12:03am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/2 "2023-01-07T00:03:40Z")
You can add a **Ratings** table to help with that. The structure would be somewhat like this. | User ID | Company ID | Rating | Comment | | --- | --- | --- | --- | | abcde | gfhij | 4 | Great service! | I assume you may only want a user to rate a company once. - Create a “Rate & Comment” button on each company’s detail screen. - The form would contain a rating component and a text component (for comments). It will also collect the user’s rowID (from the Users table) and the company’s rowID (from the current table - Companies table). - In the Companies table, create a template joining the signed-in user’s rowID with each row’s company rowID. - In the Ratings table, create a template joining the user ID with the company ID. - Create a relation from the Companies table to the Ratings table using the 2 templates above. - If the relation is not empty, hide the “Rate & Comment” button. ---
**Author:** ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)\ **Post date:** [January 7, 2023, 9:12am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/3 "2023-01-07T09:12:00Z")
I should be able to follow that. With this method could other users see other people ratings? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 7, 2023, 9:14am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/4 "2023-01-07T09:14:29Z")
Yes. The only things that would prevent that would be Row Owners or User Specific Columns, and Thinh hasn’t suggested using either. ---
**Author:** ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)\ **Post date:** [January 7, 2023, 12:43pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/5 "2023-01-07T12:43:52Z")
User details are in the USer sheet. Am struggling to get the real data to come through, as reviews look like this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7bc4b209b20b8d264c08a4c0fa9b281d4312a9ea.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 7, 2023, 12:50pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/6 "2023-01-07T12:50:25Z")
Looks like you’re displaying the RowID in the collection. Try changing that. ---
**Author:** ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)\ **Post date:** [January 7, 2023, 12:53pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/7 "2023-01-07T12:53:27Z")
Only options I generally have there are these: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5ef94c6bc15e1e05299cfc6c5c716c325f7f45f5.png) Think I may have configured something wrong. The combining of Company ID and User ID is happening on the company table ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 7, 2023, 1:00pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/8 "2023-01-07T13:00:45Z")
Looks like you’re missing this: > [@ThinhDinh](#): > > It will also collect the user’s rowID (from the Users table) and the company’s rowID (from the current table - Companies table). You need two more columns in your Reviews table - one for UserID and one for CompanyID. Both of these should be populated from your Review Form. The CompanyID will be available as a Screen Value, and the UserID can be taken from the User Profile of the user submitting the form. Once you have those values being recorded, you can use them to build the relation that @ThinhDinh described: > [@ThinhDinh](#): > > - In the Companies table, create a template joining the signed-in user’s rowID with each row’s company rowID. > - In the Ratings table, create a template joining the user ID with the company ID. > - Create a relation from the Companies table to the Ratings table using the 2 templates above. ---
**Author:** ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)\ **Post date:** [January 7, 2023, 2:44pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/9 "2023-01-07T14:44:35Z")
Have had these all along - as in this screeny. You can see the template setup on the left ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a781c6e0d47df2b45337ea6799fc0562da86780d.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 7, 2023, 2:51pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/10 "2023-01-07T14:51:35Z")
No, that doesn’t look right. Which table is that screen shot from? ---
**Author:** ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)\ **Post date:** [January 7, 2023, 2:53pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/11 "2023-01-07T14:53:39Z")
The company table. This is the config of the review table (with a couple of test entries) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20e8e9710794aaa4dbbcaeb4e68361e4201c78f5.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 7, 2023, 2:56pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/12 "2023-01-07T14:56:19Z")
Okay, good. That looks better. Now, back to your earlier issue with the display of the ratings. What information do you want shown in that collection? Do you want the name of the user that left the review, or…? ---
**Author:** ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)\ **Post date:** [January 7, 2023, 2:57pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/13 "2023-01-07T14:57:50Z")
Yes name of the user + the company name. I can get the bottom to section of the below example, but don’t know how to get it to pull the company name or user who left review name. My only options are: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/6811826f4502d6980b7e5fd2eb922dce9d4c2c3b.jpeg) So it will be like: Review of ‘Google’ by ‘Joe Bloggs’ Rating ⭐⭐ Detail/comment: ‘blah etc.’ ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 7, 2023, 3:00pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/14 "2023-01-07T15:00:42Z")
Okay, no problem. To get the name of the user: - Create a single relation in your Review table that matches the UserID to Users-\>UserID - Then add a lookup column that fetches the user name via that relation. To get the name of the company, you essentially do the same thing, ie: - A single relation that matches CompanyID to Companies → ID (RowID) - A lookup to fetch the Company name Once you have each of those, you can use a template column to combine them into the below: > [@kickso](#): > > Review of ‘Google’ by ‘Joe Bloggs’ ---
**Author:** ![kickso](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kickso](https://community.glideapps.com/u/kickso)\ **Post date:** [January 7, 2023, 3:02pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/15 "2023-01-07T15:02:28Z")
You beauty, thanks!!! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 8, 2023, 3:03pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-review-or-comment-on-a-collection-item/56419/16 "2023-01-08T15:03:02Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.