# Hyperformula - what is computed when (and so wrong or blank value is saved on action)

**URL:** <https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661>\
**Category:** Ask for Help\
**Created:** [November 17, 2021, 4:02pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661 "2021-11-17T16:02:59Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [November 17, 2021, 4:02pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/1 "2021-11-17T16:02:59Z")

</div>

Annoying thing…  
I have a name field - legalname - and I need to split it into first and last name  
I have been using a hyperformula to do the split  
and now trying to write in the computed value to a webhook to send to integromat  
BUT  
the value is not being picked up - so I get a blank value passed through to integromat

Has anyone else had this issue? Thanks! M

 ![Screenshot 2021-11-17 at 17.00.43](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de873403474b4b13985ff0b79b8dfec5a3c7600d.png)

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [November 17, 2021, 4:04pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/2 "2021-11-17T16:04:03Z")

</div>

If I’m not wrong, you couldn’t send values coming from a plugin to integromat…

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [November 17, 2021, 4:10pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/3 "2021-11-17T16:10:29Z")

</div>

That should be wrong.

Hyperformula (and JavaScript) columns run in a more secure ‘sandboxed’ mode ([you can see this here](https://github.com/glideapps/glide-code-columns/blob/master/src/columns/hyperformula.ts#L22)). This could be introducing a crucial delay that misses the value when sending the webhook. We’ll have to take a look to see if we can ensure the sandboxed plugins get enough time to produce their results when running in actions.

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [November 17, 2021, 4:14pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/4 "2021-11-17T16:14:59Z")

</div>

I was never able to send values coming from a plugin to Integromat, and if I’m not wrong someone mention the same a while back, that’s why I mentioned it. But thank you for the clarification David. But I only tried it with the Yes Code column, maybe that’s why…

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [November 17, 2021, 4:15pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/5 "2021-11-17T16:15:20Z")

</div>

I have realized that in many cases, the values are empty when passed to Integromat via webhook. This is obviously not great… but I can work around some things at least. Thanks!

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [November 17, 2021, 4:25pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/6 "2021-11-17T16:25:14Z")

</div>

I believe Mark said that the value needs to be on the screen for it to go on the webhook.

Also, if I’m not mistaken, @ThinhDinh has been able to pass values form code columns through webhooks by doing having them on the screen.

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [November 17, 2021, 4:42pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/7 "2021-11-17T16:42:50Z")

</div>

the values need to be on screen in some way… so a rich text component which turns the text white on a white background kind of thing?

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [November 17, 2021, 7:27pm UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/8 "2021-11-17T19:27:56Z")

</div>

Right Mark!

That is the current trick I know for it

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 18, 2021, 12:14am UTC](https://community.glideapps.com/t/hyperformula-what-is-computed-when-and-so-wrong-or-blank-value-is-saved-on-action/34661/9 "2021-11-18T00:14:01Z")

</div>

I just hide the text using a condition that is never true. That still forces Glide to compute for it. To add an additional measure to make sure the value is computed, I set my button’s visible condition to if the value in question is not empty.
