# The value in the cell is not displayed when adding a new record

**URL:** <https://community.glideapps.com/t/the-value-in-the-cell-is-not-displayed-when-adding-a-new-record/67966>\
**Category:** Ask for Help\
**Created:** [November 20, 2023, 11:23am UTC](https://community.glideapps.com/t/the-value-in-the-cell-is-not-displayed-when-adding-a-new-record/67966 "2023-11-20T11:23:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Artem\_Lisenkov](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/artem_lisenkov/32/62415_2.png) [@Artem\_Lisenkov](https://community.glideapps.com/u/Artem_Lisenkov)\
**Post date:** [November 20, 2023, 11:23am UTC](https://community.glideapps.com/t/the-value-in-the-cell-is-not-displayed-when-adding-a-new-record/67966/1 "2023-11-20T11:23:12Z")

</div>

Hello! For correct calculations in the application, you need to know the current exchange rate. I tried using the function “Google Finance(“USDEUR”;“price”; A2:A)”, however, the problem is that when adding a new entry to the table, this formula is not executed. That is, instead of the exchange rate, there is an empty cell. How can I make this formula work correctly? Or maybe there are some other possibilities with which I can find out the exchange rate I need?  
I will be very grateful for your help!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 20, 2023, 11:29am UTC](https://community.glideapps.com/t/the-value-in-the-cell-is-not-displayed-when-adding-a-new-record/67966/2 "2023-11-20T11:29:22Z")

</div>

My suggestion would be to subscribe to an Exchange Rate API service (there are plenty of them out there), and then make an API call directly from the App whenever you need to. This would give you instant results, which you will never get if you’re using Google Sheet formulas.

---

<div class="post-metadata">

**Author:** ![Artem\_Lisenkov](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/artem_lisenkov/32/62415_2.png) [@Artem\_Lisenkov](https://community.glideapps.com/u/Artem_Lisenkov)\
**Post date:** [November 20, 2023, 11:47am UTC](https://community.glideapps.com/t/the-value-in-the-cell-is-not-displayed-when-adding-a-new-record/67966/3 "2023-11-20T11:47:14Z")

</div>

I would like to do this using tables, since a business subscription is needed to use the Call APU, for me it is quite expensive. Do you have any thoughts?

---

<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 20, 2023, 11:28pm UTC](https://community.glideapps.com/t/the-value-in-the-cell-is-not-displayed-when-adding-a-new-record/67966/4 "2023-11-20T23:28:51Z")

</div>

Maybe you can try fetching the API using a JavaScript column. That is available on all plans.