Skip to main content
Solved

Average Rating from multiple collaborators

  • March 15, 2022
  • 3 replies
  • 34 views

Forum|alt.badge.img+2

Hey,
Is it possible to rate one record multiple times (1 collaborator to rate same recordmultiple times), and later on to show an average rating? And to do that with multiple collaborators?
For example, restaurant review, Can I rate the same restaurant multiple times, and calculate the average rating for that particular restaurant? And that average rating to be a combination of multiple different ratings from multiple collaborators.
I’m not quite sure how to do that…
Thanks

Best answer by Mohamed_Swella1

Hi @Michael1 ,

To do something like that you would need to have a table called Rating that is linked to the Restaurant table. Then add a Rollup Field in the Restaurant table that would then average the different ratings entered.

3 replies

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Michael1 ,

To do something like that you would need to have a table called Rating that is linked to the Restaurant table. Then add a Rollup Field in the Restaurant table that would then average the different ratings entered.


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • March 16, 2022

Hi @Michael1 ,

To do something like that you would need to have a table called Rating that is linked to the Restaurant table. Then add a Rollup Field in the Restaurant table that would then average the different ratings entered.


Hey Mohamed,
Thanks for your reply.
In the end, I made something like that.
Thanks for your reply!


Forum|alt.badge.img+1
  • New Participant
  • August 7, 2023

Hi @Michael1 ,

To do something like that you would need to have a table called Rating that is linked to the Restaurant table. Then add a Rollup Field in the Restaurant table that would then average the different ratings entered.


How would I set up an interface for people to go through a list of items to rate? I assume that with each edit, a new line would be added to the ratings table. Or would this have to be done in a form?