Multi-level Relation Column to display Calendar view

As the app setup gets more and more complex I’m struggling to solve this one…

Objective: In the user’s profile page (see below) I wish to list the classes (calendar view) that a user has check-in into.


Check-ins (I have created the correct Lookup columns)


PROBLEM: I can not see the Lookup (Class, Date) columns created in the Check-ins sheet above

I haven’t studied your question or thought too hard on this answer, so forgive me if I’m way off, but sometimes you need to make sure your relation is a single (not multiple) relation. That will return a single lookup result which will help it show up in the list of available columns. Otherwise it’s treated as an array value and can’t be used in areas of the builder that require a single value.

1 Like

aah! I didn’t know that - that was exactly the issue, I changed the relation to ‘not-mulitiple’ and I was able to see the single value lookup columns - thanks Jeff :slight_smile:

1 Like