Skip to main content

Why Can't I Select a Lookup Column to Display Values?

How to displaying lookup column

Updated over 10 months ago

The Lookup column in Glide is designed to fetch and return an array of values based on a relation. However, most Glide components are built to display single values rather than arrays. As a result, you may not find the Lookup column available for selection in certain components because it returns multiple values instead of a single one.

How to Work Around This Limitation

To work around this limitation you can use a Joined List column: Instead of using a Lookup column, create a Joined List column to combine the multiple values into a single, comma-separated string. This converts the array into a single value, making it compatible with components that only accept single values.

In summary, the reason you can’t directly display a Lookup column in many Glide components is because it returns an array of values. To resolve this, use a Joined List column to merge multiple values into a single, delimited string.

Did this answer your question?