# search by hs\_searchable\_calculated fields

**URL:** <https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519>\
**Category:** APIs & Integrations\
**Tags:** companies\
**Created:** [May 23, 2022, 3:19pm UTC](https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519 "2022-05-23T15:19:03Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![IG1](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@IG1](https://community.hubspot.com/u/IG1)\
**Post date:** [May 23, 2022, 3:19pm UTC](https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519/1 "2022-05-23T15:19:03Z")

</div>

Hello, i’m trying to search for companies by phone, that doesn’t have standard view (1 800 555 3535, 1 800 555 35 35, 1800 555 3535). I found `hs_searchable_calculated_*`, but all claculated\_props from [hubspot-props](https://github.com/kerwinso/hubspot-api/blob/master/hubspot-contact-properties.tsv) doesn’t work with companies, although with contacts it works fine. Is there any other way to properly find a company by phone on hubspot side. Way with adding a lot of phone variation to filterGroups looks not good. Thank you and sorry for bad english 🙂

```lia-code-sample
// POST https://api.hubapi.com/crm/v3/objects/contacts/search
{
 "limit": 1,
 "sorts": [
 {
 "propertyName": "createdate",
 "direction": "DESCENDING"
 }
 ],
 "properties": [
 "email",
 "phone",
 "firstname",
 "lastname",
 "createdate"
 ],
 "filterGroups": [
 {
 "filters": [
 {
 "value": "18005554545",
 "propertyName": "hs_searchable_calculated_phone_number",
 "operator": "CONTAINS_TOKEN"
 }
 ]
 }
 ]
}

```

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [May 23, 2022, 11:50pm UTC](https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519/2 "2022-05-23T23:50:37Z")

</div>

Hi, @IG1! Thank you for taking the time to give context to your issue and for including your code example. Hey, @RMones @RomanGruit @jpsanchez do you have any insight or next steps for @IG1?  
Thank you! – Jaycee

---

<div class="post-metadata">

**Author:** ![RomanGruit](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/romangruit/32/84954_2.png) [@RomanGruit](https://community.hubspot.com/u/RomanGruit)\
**Post date:** [May 24, 2022, 6:20am UTC](https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519/3 "2022-05-24T06:20:08Z")

</div>

Hi @IG1,  
The first that comes to my mind is to create the hs\_searchable\_calculated\_phone\_number field for companies.  
Just run through every company record and create hs\_searchable\_calculated\_phone\_number based on the existing phone field. Does it make sense for you?

---

<div class="post-metadata">

**Author:** ![IG1](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@IG1](https://community.hubspot.com/u/IG1)\
**Post date:** [May 24, 2022, 7:39am UTC](https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519/4 "2022-05-24T07:39:01Z")

</div>

can’t create a property with this name - `A property with the internal name “hs_searchable_calculated_phone_number” already exists or is restricted.`

---

<div class="post-metadata">

**Author:** ![IG1](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@IG1](https://community.hubspot.com/u/IG1)\
**Post date:** [May 24, 2022, 7:45am UTC](https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519/5 "2022-05-24T07:45:57Z")

</div>

there is also a problem with adding new fields - I need to add this field every time a new company is created. I think keeping it synchronized is quite difficult

---

<div class="post-metadata">

**Author:** ![jpsanchez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jpsanchez/32/106486_2.png) [@jpsanchez](https://community.hubspot.com/u/jpsanchez)\
**Post date:** [May 24, 2022, 8:09am UTC](https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519/6 "2022-05-24T08:09:39Z")

</div>

Hi,

Not sure about your sentence. ..  
What i have in mind.

1.- Create in Hubspot a new property. Name it as you wish to. In the creation process check the box related to i want this property to be searchable.. bla bla.

2.- Create a Workflow. Name it as you wish to. This WF will start when the original property from Company/phone is know. Next will copy the content to the new property you create in step 1.  
END---  
3.- PRODUCTION USE.- changes to do.

Add the new property name in the “properties”: bla bla bla…

Modify Filter Group by adding the new property create it in step 1.  
( i paste again your code here in order to be more readeable.)

Final point. You don´t have to create each time a property as you mention, not sure what do you mean, if you could please give more details will be great!

Best.

```auto
// POST https://api.hubapi.com/crm/v3/objects/contacts/search
{
 "limit": 1,
 "sorts": [
 {
 "propertyName": "createdate",
 "direction": "DESCENDING"
 }
 ],
 "properties": [
 "email",
 "phone",
 "firstname",
 "lastname",
 "createdate"
 ],
 "filterGroups": [
 {
 "filters": [
 {
 "value": "18005554545",
 "propertyName": "hs_searchable_calculated_phone_number",
 "operator": "CONTAINS_TOKEN"
 }
 ]
 }
 ]
}

```

``

---

<div class="post-metadata">

**Author:** ![jpsanchez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jpsanchez/32/106486_2.png) [@jpsanchez](https://community.hubspot.com/u/jpsanchez)\
**Post date:** [May 24, 2022, 6:51am UTC](https://community.hubspot.com/t/search-by-hs-searchable-calculated-fields/57519/7 "2022-05-24T06:51:08Z")

</div>

Hi,

I guess a walk arround will work. (/ this happen with other properties in objects)  
Create a new Company/property that mirrows the Company/phone. ( that can be done with a workflow)

Select for search this new property.

It should work.

Best

JP