Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Format into a Rating

cancel
Showing results for 
Search instead for 
Did you mean: 
Frite666
5 - Automation Enthusiast
5 - Automation Enthusiast
Status: New Ideas

With Rating being a type, it should be possible to format look up and formula into a directly into Rating.

Right now this is not possible, without the use of Automation even so a rating is a disguised Number.
Adding this functionnaly would help application
that have to deal with things like community ratings.

Because a Rating is Number between 0 and a max rating, the resulting value in a formula should be clamp with 0 as the min and the max rating as the max.

7 Comments
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @Frite666!

I donโ€™t think I am fully following the idea/issue. Would you mind providing further context?

Mike, Consultant @ Automatic Nation

ScottWorld
18 - Pluto
18 - Pluto

@Frite666 

Yes, that would be a nice feature to have.

Rating fields are currently โ€œstuckโ€ in their own table & their own field, because they canโ€™t be looked up in any other tables with any of their formatting intact, nor can the results of a formula field be turned into ratings.

One of the options we currently have is to use an automation to copy and paste their values into another designated rating field.

- ScottWorld, Expert Airtable Consultant 

Frite666
5 - Automation Enthusiast
5 - Automation Enthusiast

@Mike_AutomaticN 

Sorry, if i am unclear, english isn't my native language.

The issue i have has to do with using a lookup field to get value from a Rating field.

But because it is impossible to format a value from a lookup field as a Rating the value when diplayed inside my Interface/Form is simply a Number and the only way to display it has a Rating would be to use Automation instead of a lookup field.

This issue does'nt happen with some field such as Currency field because lookup and formula fields can be format into a currency field.

The idea i have is simply to add the possiblity to format a lookup field into a Rating field and do the same with formula (in case the resulting value is higher than the maximum value of the Rating then the value should be set to the maximum)

To be honest it isn't a technical issue it is just for constency

kuovonne
18 - Pluto
18 - Pluto

I imagine that lookup fields cannot be displayed as rating fields because showing multiple values as a rating would be visually challenging, and lookup fields are designed to be able to show multiple values, even if there is only one value for a particular data set.

In the meantime, until Airtable implements something native, you can use a workaround with a rollup field. Here is an example rollup formula that takes the average rating and repeats the star emoji that many times. If you want the minimum or maximum rating, use the MIN() or MAX() functions instead of AVERAGE().

 

 

IF(
  COUNT(values),
  REPT("*", ROUND(AVERAGE(values), 0))
)

 

Edit: Well, this forum doesn't want to show the star emoji (โญ) in my formula. So I replaced it with an *. Same concept.

 

ScottWorld
18 - Pluto
18 - Pluto

Great tip from @kuovonne!

Mike_AutomaticN
10 - Mercury
10 - Mercury

Interesting.. Nice one @kuovonne

Frite666
5 - Automation Enthusiast
5 - Automation Enthusiast

@kuovonne 

Thank you for the workaround  !