Relation "How to" (if it's possible)


I’d like to get a value from a sheet which is not in the main one.
As you can see on the picture, i’d like to get a value, and not an inline list (with the Relation Component).


  • Create a Single Relation from your Users table to your Rooms table, using the Group column in each
  • Add a Lookup column to your Users table, fetching the Room number via that relation

Thanks a lot. Perfect.
The solution with an image for the community.

1 Like