Clay Icon
Join the Community
02 Support

How to Set HubSpot Lookup Column Filter for Scoring Field

Avatar of Allister P.Allister P.
·
·

Hi question - I am trying to do a Hubspot lookup column based on a scoring field - is there a way to set the property filter to >0 ? See screenshot :

7 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can set a property filter for values greater than 0 in a Hubspot lookup column. When configuring your Hubspot lookup:1. Select your Hubspot account 2. Choose your Object Type 3. In the "Fields to Filter By" section, select your scoring field 4. For the Search Operator, you can use the "greater than" comparison operator 5. Enter "0" as your Filter Field Input value Sources: Hubspot integration overview | Documentation | Clay University Hide, Re-order, Sort, Filter, Merge Columns

  • Avatar of Allister P.
    Allister P.
    ·
    ·

    I can't find the search operator section to use "greater than" can you send me a screenshot please

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    I apologize, but I cannot send screenshots. However, I can guide you through the process:When setting up a Hubspot lookup column:1. Select your Hubspot account 2. Choose your Object Type 3. Look for "Fields to Filter By" section and select your scoring field 4. For each filter field you select, you should see options to specify the search criteria 5. The Search Operator field is where you can specify how multiple filters are combined (using AND/OR logic)If you're not seeing these options, you may need to reach out to a human agent for visual guidance. Please let me know if you'd like to speak with one. Source: Hubspot integration overview | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

  • Avatar of Jacob T.
    Jacob T.
    ·
    ·

    Allister P. hey hey - if you want live help, happy to hop on a zoom call to debug. I don't work for Clay, but I do focus on integrating Clay <> HubSpot specifically, so may be able to solve for you.