Improving 'Select' Column Display for Better Data Lookup Clarity

Seb H. · 2025-02-26T17:25:20.763784+00:00

When you lookup data in another table, if one of the fields is a 'Select' column, the value selected will never appear as text and rather the id that the selected value is assigned. It would be nice if it would grab the text value so that you don't have to setup complex and unnecessary formulas without making the column in the original table just a 'Text' field.

Currently, when looking up data from a 'Select' column, Clay displays the assigned ID rather than the text value. We're aware this can be inconvenient for users who need to see the actual text without setting up complex formulas. To work around this limitation, you could consider changing the 'Select' column to a 'Text' column in the original table. This would allow the text value to be displayed directly when looking up data. To change a column's data type: 1. Right-click the column you want to edit 2. Click "Edit Column" > "Select Data Type" 3. Choose "Text" as the data type 4. Click "Save Settings" Is there a specific reason you need to keep the column as a 'Select' type rather than 'Text'?

Sources: Select Column Data Type Table columns overview | Documentation | Clay University

1 comment