Display most recent ratings

[Adam_Chambers]

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?

[Darren_Murphy]

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.