Now you can "look" into the related table without SQL or any code. Just link the tables or connected the resource with already established relations and use
Lookups and Rollups
through a point-and-click interface. Or set a custom function with Computed field
.👩🎓 More about Lookups & Rollups in our
documentation
.👀 Look out for the upcoming version where you'll be able to use Lookups and Rollups
across multiple data sources
.