CRM

seliMiles
メンバー

Filtering a view with a comma separated list of company IDs

解決

Is it possible to create either an active list, or a company view where Company ID = multiple IDs? E.g. Company ID is one of Company ID1, Company ID2, Company ID3

 

The only way I've been able to do this so far is to create a list with multiple OR statements for Company ID, and then create a Company view for companies that are list members of this list....but this isn't scalable:

seliMiles_0-1603475704322.png

 

I have tried importing a single column CSV of Company IDs in the hopes I could then use that as a static list, and then create a company view where the company is a list member of that uploaded list. However the single column upload file fails.

If anyone has any info to share that would be great.

3件の承認済みベストアンサー
karstenkoehler
解決策
殿堂入り | Solutions Partner
殿堂入り | Solutions Partner

Filtering a view with a comma separated list of company IDs

解決

Hi @seliMiles,

 

You should be able to copy multiple values at once by putting them in one column and filling a second column with semicolons, as shown in the screenshot below:

 

copy.png

 

When you select and copy A1:B4, then paste it into the 'is equal to any of' field in HubSpot, the system should recognize separate values.

 

Hope this helps!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

元の投稿で解決策を見る

GRajput
解決策
名誉エキスパート | Platinum Partner
名誉エキスパート | Platinum Partner

Filtering a view with a comma separated list of company IDs

解決

Hi @seliMiles - Yes it is possible to create either an active list, or a company view where Company ID = multiple IDs

1. Create a Company property of single-line text type and name it such as "Temporary company id".

GRajput_0-1646944098352.png

 

2. Create a workflow and set trigger value where company id is known

   Then , Copy company property Company ID to company property Temporary company id

GRajput_1-1646944127138.png

 

3. After creating workflow we create an active list of company view where company id=multiple id

GRajput_2-1646944127091.png

 

GRajput_3-1646944127107.png

 

I hope this will help you out.

 

Thanks,

Gaurav R




Gaurav Rajput
Director, MarTech( Growth Natives)

Book a meeting


元の投稿で解決策を見る

asgeirbambusa
解決策
参加者

Filtering a view with a comma separated list of company IDs

解決

Workaround solution for the field "is qual to": replace the semicolons (;) with OR

元の投稿で解決策を見る

12件の返信
GRajput
解決策
名誉エキスパート | Platinum Partner
名誉エキスパート | Platinum Partner

Filtering a view with a comma separated list of company IDs

解決

Hi @seliMiles - Yes it is possible to create either an active list, or a company view where Company ID = multiple IDs

1. Create a Company property of single-line text type and name it such as "Temporary company id".

GRajput_0-1646944098352.png

 

2. Create a workflow and set trigger value where company id is known

   Then , Copy company property Company ID to company property Temporary company id

GRajput_1-1646944127138.png

 

3. After creating workflow we create an active list of company view where company id=multiple id

GRajput_2-1646944127091.png

 

GRajput_3-1646944127107.png

 

I hope this will help you out.

 

Thanks,

Gaurav R




Gaurav Rajput
Director, MarTech( Growth Natives)

Book a meeting


JLestréhan
参加者

Filtering a view with a comma separated list of company IDs

解決

Actually an answer! Thanks a lot @GRajput 

kvlschaefer
コミュニティーマネージャー
コミュニティーマネージャー

Filtering a view with a comma separated list of company IDs

解決

Thanks for sharing, @GRajput


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

Filtering a view with a comma separated list of company IDs

解決

I landed here with the same problem, and the issue is that with Contact ID we don't have the `is equal to any of` option.

AAugustine
参加者

Filtering a view with a comma separated list of company IDs

解決

Any update on this? That particular contact id field is not taking multiple values. Please update that text box to accept multiple values with OR or semi column seperation.

karstenkoehler
解決策
殿堂入り | Solutions Partner
殿堂入り | Solutions Partner

Filtering a view with a comma separated list of company IDs

解決

Hi @seliMiles,

 

You should be able to copy multiple values at once by putting them in one column and filling a second column with semicolons, as shown in the screenshot below:

 

copy.png

 

When you select and copy A1:B4, then paste it into the 'is equal to any of' field in HubSpot, the system should recognize separate values.

 

Hope this helps!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

JerrySuhrstedt
メンバー

Filtering a view with a comma separated list of company IDs

解決

@Anonymous dude, this comment just ended two hours of research.  Been trying to paste in multiple values from an excel spreadsheet.

Thanks!!!!

AAugustine
参加者

Filtering a view with a comma separated list of company IDs

解決

This is not working for the contact id field, but worked for most other fields. Why is the contact id field textbox set to accept only one value? It does not take more values even on typing manually. 

seliMiles
メンバー

Filtering a view with a comma separated list of company IDs

解決

Thanks for the response. For whatever reason I can't get HubSpot to accept it...

 

multiselect.gif

BencoCreative
メンバー

Filtering a view with a comma separated list of company IDs

解決

Hey seliMiles - I'm sure this is long since resolved (or given up on!) - but I was tackling similar solutions related to copy/paste use of data - for the benefit of anyone else landing on this thread, the problem being faced above is because the field being pasted into is a 'is equal to' field, and not an 'is equal to any of' field. The latter accepts multiple entries, and works fine with copy / paste data from my experience; whereas the former does not. 

asgeirbambusa
解決策
参加者

Filtering a view with a comma separated list of company IDs

解決

Workaround solution for the field "is qual to": replace the semicolons (;) with OR

kvlschaefer
コミュニティーマネージャー
コミュニティーマネージャー

Filtering a view with a comma separated list of company IDs

解決

Thanks for sharing this workaround, @asgeirbambusa!


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