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 .
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.
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:
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�
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: