# Name Formula is not working

**URL:** <https://community.fibery.io/t/name-formula-is-not-working/4946>\
**Category:** Bugs & Issues\
**Created:** [August 11, 2023, 8:46pm UTC](https://community.fibery.io/t/name-formula-is-not-working/4946 "2023-08-11T20:46:15Z")\
**Posts on this page:** 10\
**Page:** 2

<div class="post-metadata">

**Author:** ![Sergey\_Truhtanov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/sergey_truhtanov/32/13986_2.png) [@Sergey\_Truhtanov](https://community.fibery.io/u/Sergey_Truhtanov)\
**Post date:** [August 25, 2023, 4:08pm UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/21 "2023-08-25T16:08:42Z")

</div>

Unfortunately I can’t answer this question ☹  
Seems like the only way is to try.  
We have some low level limits, like database query timeout (we use postgres), etc.  
It’s hard to say when those will start alerting, as it’s highly dependent your data, views configuration, etc.  
The more complex your formula is, the higher chance is that it will fail with a timeout if db size is huge. We have monitoring for all this, and for the moment it’s all fine with rare exceptions.

We don’t have limits for work in automations (except scripts), but you can easily overflow your workspace with huge amount of work.  
There may be other limits. Say you create a time-based rule, that is executed for all 300k entities. It will fail most likely. As I remember we limit that number to 20k.

In general we are thinking about introducing some db size limits. In order not to give falsy promises to our users. Not sure how we will proceed with existing workspaces though.  
I suggest you to keep your database size around 300k limit for system to perform good enough.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [August 25, 2023, 5:01pm UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/22 "2023-08-25T17:01:27Z")

</div>

In case it makes a difference, and to inform your future policies:

I do have a LOT of data in this Workspace, being imported via a custom Integration with Zoho CRM – there are ~2M entities with lots of internal links and Formula fields.

But the actual Workspace USAGE _by users_ is very low, because the entire purpose of the Workspace is only for generating reports on all that data, to be viewed by just a few users.

---

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [August 29, 2023, 7:51am UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/23 "2023-08-29T07:51:16Z")

</div>

@Matt_Blais @Sergey_Truhtanov  
Thanks for all the information. Need to reconsider some parts of the workspace to make sure it works well in the future.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [September 24, 2023, 10:20pm UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/24 "2023-09-24T22:20:56Z")

</div>

@Sergey_Truhtanov, when using `updateEntityBatch()`, how do we specify entity Ids of entities to update?

> ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/9893b266f80741fc1ac36662d0172d5340903374.png)

---

<div class="post-metadata">

**Author:** ![Sergey\_Truhtanov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/sergey_truhtanov/32/13986_2.png) [@Sergey\_Truhtanov](https://community.fibery.io/u/Sergey_Truhtanov)\
**Post date:** [September 25, 2023, 8:30am UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/25 "2023-09-25T08:30:25Z")

</div>

Unlike `updateEntity` api that has signature

```auto
updateEntity(type: string, id: string, values: object): Promise<object>;

```

`updateEntityBatch` has the following api (takes 2 parameters, each entity in second `entities` parameter is expected to have an id)

```auto
updateEntityBatch(type: string, entities: object[]): Promise<object[]>;

```

example:

```auto
await fiberyService.updateEntityBatch("Space/Type", [{"fibery/id": "someId", "Space/Name" : "updatedName"}]

```

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [September 25, 2023, 3:15pm UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/26 "2023-09-25T15:15:25Z")

</div>

Yes, that is exactly what I am doing, but still I get the error.

Here is the call I am making::

```auto
fibery.updateEntityBatch( "REPORTS/Call Stats", [
  {
    'fibery/id': 'a02a505f-45f3-46c3-a101-1423cd18624b',
    'REPORTS/Reassociate': true
  },
  {
    'fibery/id': '0c017169-6182-47a5-8471-18b64ccc5e83',
    'REPORTS/Reassociate': true
  },
  {
    'fibery/id': '7799ac8b-b239-466c-95a4-db82e3233038',
    'REPORTS/Reassociate': true
  }, ...
])

6953.cab21708.chunk.js:1 [ArgumentValidationError: updateEntityBatch: entity id is not defined] {
  name: 'ArgumentValidationError'
}

```

---

<div class="post-metadata">

**Author:** ![Sergey\_Truhtanov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/sergey_truhtanov/32/13986_2.png) [@Sergey\_Truhtanov](https://community.fibery.io/u/Sergey_Truhtanov)\
**Post date:** [September 25, 2023, 4:03pm UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/27 "2023-09-25T16:03:24Z")

</div>

Omg. Sorry, I didn’t notice from the beginning.  
We try to allow author of the script to use field names without space names where possible.  
And I’ve made this batch api with same thing in mind, so you should write

```auto
await fiberyService.updateEntityBatch("Space/Type", [{"id": "someId", "Name" : "updatedName"}]

```

For other fields you may use or not use space prefix. I forgot to allow this for `id` field, so `fibery/id` is not supported. Will look into fixing that. For now please use `id` as a key.  
Btw editor should highlight your call with red, as I explicitly require `id` in editor interface definition.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [September 25, 2023, 5:19pm UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/28 "2023-09-25T17:19:52Z")

</div>

Thanks – using “id” works 👍

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [September 25, 2023, 5:22pm UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/29 "2023-09-25T17:22:32Z")

</div>

To close this Issue – the cause of the blank Name fields was that the Fibery backend took some time catching up and updating all the Formulas.

There is unfortunately no indicator in the UI to inform you that the current entity/view is still updating…

---

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [September 29, 2023, 8:33am UTC](https://community.fibery.io/t/name-formula-is-not-working/4946/30 "2023-09-29T08:33:46Z")

</div>



[Previous page](https://community.fibery.io/t/name-formula-is-not-working/4946.md?page=1)