Tips on using Ratings

After a day of experimenting… (why can’t the SC team write decent technical notes???)

Ways of using Ratings: (Specifically the star rating field type, may apply to others)

  1. Data must be INTEGER. It will match 4 or 4.0 as 4 stars but not 3.9, 4.1,4.2 etc. (they show as 0 stars) Solution CAST the data to DECIMAL (1,0) if needed to make this work.

  2. Empty stars will be displayed if the field value is NULL or 0. To display a completely blank field (e.g. the absence of a score rather than a score of 0) set the value of the field to be -1. This can be achieved in the data record or by using the event onRecord if required. e.g.

    if ({my_rating} IS NULL OR {my_rating} == 0)
    {
    {my_rating} = -1;
    }

3 Likes