How to Set HubSpot Lookup Column Filter for Scoring Field | Clay

How to Set HubSpot Lookup Column Filter for Scoring Field

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 :

6 comments

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
Allister P.
·
·
I can't find the search operator section to use "greater than" can you send me a screenshot please
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
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!
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.
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.