Tip
Short answer: Rating fields are stored as numbers. Compute a Number field with the Rating field's ID and it shows the rating as a number.
When to use this
Use this when you collect star ratings, for example in an appraisal form, but also need the score as a number to total, average or report on.
Set it up
- Add a Rating field, for example
Performance_Rating. - Add a Number field and turn on Is this a computed field?.
- Enter the Rating field's ID as the formula, for example
Performance_Rating. - Save the field. When someone rates, the Number field shows the score.
Rating and slider fields work as number fields in any expression, so you can also use them directly in other calculations.
Tip
If you turn on half-star ratings, the Number field shows decimals such as 3.5. Set its number of decimal places to at least 1.
