# Showing numeric grades as letters **URL:** \ **Category:** Ask for Help\ **Created:** [July 22, 2025, 2:57pm UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367 "2025-07-22T14:57:19Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![BungaWunga\_Wunga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungawunga_wunga/32/78506_2.png) [@BungaWunga\_Wunga](https://community.glideapps.com/u/BungaWunga_Wunga)\ **Post date:** [July 22, 2025, 2:57pm UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/1 "2025-07-22T14:57:19Z")
I have multiple columns with grades for 1 to 5 that are used to calculate average, etc, but I want to show them as star emoji ( ⭐ ). Is there an easy way to do it for the Field Component? When people attribute their grade, I can do it using the “Choice” component because there’s an option “Display As” and I did a table attributing each number to the right amount of stars. I could use the same data, but there’s no Display As option in Field Component. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 22, 2025, 3:10pm UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/2 "2025-07-22T15:10:23Z")
You could use an IF column to convert the numbers to emoji. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 22, 2025, 11:46pm UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/3 "2025-07-22T23:46:49Z")
![CleanShot 2025-07-23 at 06.46.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b22bcfd4a993d163f059d5519bf1a27833ee7a3.png) You can also use a Repeat Text column. ---
**Author:** ![BungaWunga\_Wunga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungawunga_wunga/32/78506_2.png) [@BungaWunga\_Wunga](https://community.glideapps.com/u/BungaWunga_Wunga)\ **Post date:** [July 24, 2025, 10:22am UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/4 "2025-07-24T10:22:39Z")
Thanks for the Answer. I have about 30 people giving their grade - I’d need one extra column per person? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 24, 2025, 10:29am UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/6 "2025-07-24T10:29:12Z")
I would advise against that, it will be very difficult to maintain. Instead you should have a separate table for Grades, with the following columns: - StudentID - AssessorID - Subject (if applicable) - Grade Each time a grading is made, add a row to that table. ---
**Author:** ![BungaWunga\_Wunga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungawunga_wunga/32/78506_2.png) [@BungaWunga\_Wunga](https://community.glideapps.com/u/BungaWunga_Wunga)\ **Post date:** [July 24, 2025, 10:39am UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/7 "2025-07-24T10:39:47Z")
Thanks for the suggestion. Actually I was searching for a display/layout solution, without using new data/columns/tables, since I already have all the grades, and I just want to display them as stars. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 24, 2025, 10:51am UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/8 "2025-07-24T10:51:47Z")
I see. Can you show me what your data looks like? Perhaps I can make a suggestion. ---
**Author:** ![BungaWunga\_Wunga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungawunga_wunga/32/78506_2.png) [@BungaWunga\_Wunga](https://community.glideapps.com/u/BungaWunga_Wunga)\ **Post date:** [July 24, 2025, 11:12am UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/9 "2025-07-24T11:12:54Z")
My data looks like a mess - but I made a quick one so you can understand what I need. I have food as rows, and eaters as columns. They evaluate the food, and I need this score showing as stars (but I need also the numeric value for calculate average and other stuff). ![Clipboard_07-24-2025_01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/6447a91f4f8410582e14fb18eda9091954a80bba.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 24, 2025, 11:39am UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/10 "2025-07-24T11:39:47Z")
Okay, I see. I think I would still suggest splitting it into two tables. Let’s say one table called Food, and another called Reviews. Here is how they might look: ![CleanShot 2025-07-24 at 19.36.47@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/49862effa115fc6cc802b29863fc4836d01f8c99.jpeg) ![CleanShot 2025-07-24 at 19.37.25@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7ff4e9c5928758594d7656d104f8665be4c29ffa.jpeg) And then in the layout, you could do something like the following: ![CleanShot 2025-07-24 at 19.39.25@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/520b5b0d98e912e4cf9cfd4fc1705b9542cc39e0.png) ---
**Author:** ![BungaWunga\_Wunga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungawunga_wunga/32/78506_2.png) [@BungaWunga\_Wunga](https://community.glideapps.com/u/BungaWunga_Wunga)\ **Post date:** [July 24, 2025, 12:47pm UTC](https://community.glideapps.com/t/showing-numeric-grades-as-letters/83367/11 "2025-07-24T12:47:23Z")
Thanks for your help!