# Display most recent ratings

**URL:** <https://community.glideapps.com/t/display-most-recent-ratings/68970>\
**Category:** Ask for Help\
**Created:** [December 23, 2023, 6:42pm UTC](https://community.glideapps.com/t/display-most-recent-ratings/68970 "2023-12-23T18:42:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adam\_Chambers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_chambers/32/67402_2.png) [@Adam\_Chambers](https://community.glideapps.com/u/Adam_Chambers)\
**Post date:** [December 23, 2023, 6:42pm UTC](https://community.glideapps.com/t/display-most-recent-ratings/68970/1 "2023-12-23T18:42:42Z")

</div>

Hi everyone, Merry Christmas.

I have a collection of different hospitals, and another with their ratings.

How can I display a section on my homepage for “most-recent” ratings that displays the hospital name, for which the rating was left, in the “title” field? My current setup is to have the hospital ID act as a signifier of who the rating is for. Is there a calculation to read the hospital ID and create a text field for the name of the hospital it’s linked to?

 ![Screenshot 2023-12-23 124135](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/372611bd75001b94df84d592281bb8ea22a7093e.jpeg)  
 ![ratings](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ea13ae0ead033bf29ae8eb32b30914d85f6d35b.png)

---

<div class="post-metadata">

**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:** [December 23, 2023, 6:46pm UTC](https://community.glideapps.com/t/display-most-recent-ratings/68970/2 "2023-12-23T18:46:09Z")

</div>

Add a single relation column that matches the Hospital ID with the same value in the Hospitals table, then use a Lookup column to fetch the name through the relation.