Paste list of values into a property filter in Company View

SOLVE
Ruscoe
Member

I want to create a new company view using a copy/pasted list of values as a filter. Usually when I create a list, I can paste a list of values into a filter easily using a semi-colon in between each one.  

 

But I don't want a list of contacts, I want a list of companies. 

 

Is there anything (like a comma or dash) to make the values appear separately, rather than in one long useless string? 

 

Screen Shot 2020-05-05 at 6.00.26 PM.png

1 Accepted solution

Accepted Solutions
warrendavey
Solution
Top Contributor | Platinum Partner

@Ruscoe - I created a video to help answer your question as part of my question of the day series.

 

Here it is: http://youtu.be/k9cE0tExqsI?hd=1

 

Currently, I wasn't able to find a way to complete your specific task in views for companies. 

 

However, I think there is an alternative solution that could work in other property criteria or even a workflow to get the result you need.  If you send me more details on how the list of store ids came about and for what purpose they are used I may be able to further answer your question.

View solution in original post

8 Replies 8
warrendavey
Solution
Top Contributor | Platinum Partner

@Ruscoe - I created a video to help answer your question as part of my question of the day series.

 

Here it is: http://youtu.be/k9cE0tExqsI?hd=1

 

Currently, I wasn't able to find a way to complete your specific task in views for companies. 

 

However, I think there is an alternative solution that could work in other property criteria or even a workflow to get the result you need.  If you send me more details on how the list of store ids came about and for what purpose they are used I may be able to further answer your question.

View solution in original post

Weerd22
Member

I was looking for the same and found this thread on the Hubspot Community website: https://community.hubspot.com/t5/HubSpot-Ideas/Copy-and-paste-multiple-cells-from-Excel-into-HubSpot...

 

The solution provided here works for me!

rico1411
Participant

I searched multiple posts and couldn't find a good answer or one that truly worked. I was able to figure it out. instead of a special character use the word OR in between each entry. Good Luck!

sharonlicari
Community Manager

Thank you for sharing @rico1411 


¿Sabías que la Comunidad está disponible en Español?
¡Participa hoy en conversaciones en el idioma de tu preferencia,cambiando el idioma en tus configuraciones!

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !


VincentTep
Participant

Hi all,

Thanks @rico1411 for this simple workaround.

However, when looking up dozens of companies, it means pasting their names into an Excel sheet to add " OR " in-between each name.

@hubspot please work on letting us paste multiple selections from Excel. Thanks!

0 Upvotes
sharonlicari
Community Manager

Hi @VincentTep 

 

Welcome to the Community!

 

I'd encourage you to upvote and comment on this idea. Our Product team is always monitoring this space to create new functionalities in our tool based on popularity.

 

Best

Sharon 


¿Sabías que la Comunidad está disponible en Español?
¡Participa hoy en conversaciones en el idioma de tu preferencia,cambiando el idioma en tus configuraciones!

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !


VincentTep
Participant

Thanks Sharon for bringing this additional tip to my attention! It still requires to tweak the original Excel file though.  But 2 workarounds are better than none (yet not as good as actually being able to paste straight into HS from Excel 😉 )

bcx
Participant

I just ran into this exact same issue, if you make a CSV file, and just end each line with a ; instead of a , you can copy and paste no problem.