Clay Icon
Join the Community
03 Feedback & Requests

Improving 'Select' Column Display for Better Data Lookup Clarity

Avatar of Seb H.Seb H.
·
·

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.

1 comment

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    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'?