Is there a way to average the "ratings"?


#1

I have a restaurant tracker that enables me, my wife and my 2 boys to each give it a rating using 1-5 stars. Is there any way to have a field that averages these stars?


#2

Yes:


#3

Thanks, but I intend to have more restaurants than just one. Will I need to do “Mom”, “Dad”, etc., over and over for each restaurant on the ratings page?


#4

Of course, that’s the Restaurants table for.

It depends on how you entered the data. In my case is just an example to answer your question. You could have for instance a SingleSelect with the names, but you have to set who belongs the rating to somehow.


#5