Clay Icon

Filtering Multiple Columns for LookUp Single Row Functionality

·
·

Is there a way to do: A “LookUp Single Row” by filtering multiple columns??

  • Avatar of LuisArturo
    LuisArturo
    ·
    ·

    Hey there Victor thanks for reaching out, can you clarify what you mean here. Do you mean as in filter through the results of a "Lookup Single Row" integration or use filters inside of a table to find a value?

  • Avatar of Victor C.
    Victor C.
    ·
    ·

    Filter through the results of a “Lookup Single Row”, Right now you can only use one single column to “Equal” or “Contain” a value, which leads to a hack of concatenating columns to be able to find values between tables among multiple columns.

  • Avatar of Arturo O.
    Arturo O.
    ·
    ·

    Hey Victor, thanks for reaching out. I'll share this as a request so our team can consider this update for this integration. Currently, as you stated, best way to achieve this is to concatenate values with formulas and looking them up in such way which understandably is bit tedious. Awesome feedback!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Victor C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback Victor C.!