Exchange Rate Updates

Support
1

Hi,

I have a sheet and the exchange rates are not updating for days at a time. Sometimes they do.

I was just wondering if there was an equivalent to “reclaculate formulas” or “sync fields” that we can use to force a refresh of exchange rates?

Thanks,

Terri

2

Hi Terri,

First of all, it’s not suggested to share your database/sheet url here directly. You can remove it if necessary. If you’d like to share with us detailed information about this issue to refer to, you can submit a ticket through “Need Help” at upper right corner in your database > Support Ticket.

And if you are referring to our exchange rate field type, the exchange rate only populates once when the entry is created, and it cannot be updated.

3

Hi Amy,

Ha, I must have looked at a record created on a different day when I Thought they had updated.

Is there no option at present to have a live pull through of an exchange rate? It seems if it can pull it live when you add the field, it should be possible to add an action button to “re-pull” the rate, as it were.

Thanks

Terri

4

Hi Terri,

Would you please let us know about your use case for having exchange rate field value updated automatically? And is it going to be automatically updated on daily basis automatically or only when you would like to re-pull it?

Thanks!

Thanks!

5

I also had the same issue with the Exchange rate,
i needed all my Prices to be updated on a daily frequency
I found a work arround that seems to work for now

I created a sheet where I have a have:

  1. a cell with a constant: “c_USD.to.TWD”
  2. auto populated date (to show the last edited date and time"
  3. exchange rate from Ragic Fx function
  4. a cell where i select a date (any cell will work, i just need to update any data on the sheet)

In this sheet I created

  1. “Update Value on Another sheet” fucntion to update in the arget sheet the Fx value
  2. link and Load to the target sheet, where I link: Constant, Fx rate, automatic updated date

In my calculation sheet i created

  1. a constant: c_USD.to.TWD
  2. link&load to the auto populated date (to visualize the last updated date)
  3. link&load to the exchange rate from Ragic Fx function
  4. url link to the Fx sheet

When I want to update the Fx i press the url link to go to the Fx page,
there I select the day of today, this will update the Fx to today, then I save the sheet.
Be carefull to select as the aditional options in “Update Value on Another sheet” to update formulas in the target sheet.

hope this helps.
Best

6

Is is possible to schedule a daily workflow script in the javascript menu pulldown that updates the exchange rate at a certain time each night, and recalculates any fields we want updated too? I also need the exchange rate updated daily with related fields kept current.

7

Hi Amy,

We would use it in our payment records.

However, the payment record is created when we receive an invoice, and marked as “Needs to be paid”.

At set times through the week, accounts then pay the outstanding invoices.

We want to be able to show the exchange rate on that day, not the day the record was created.

Therefore, I Think it would be preferable to be able to have it update when we refresh it, rather than constantly updating. However, even if constantly updating, there are workarounds and that would be preferable to being entirely fixed as it is now.

Thanks,

Terri

1 Like
8

Hi,

Looks like we can add an action button for users to execute to update the exchange rate value. We will let you know once it’s online.

9

That’s great! Thank you for looking into that.

10

Hi there, is it still the case that the exchange rate field does not automatically update?

Does an action button exist yet that can manually force an update?

Thanks

11

The exchange rate should not be updated automatically in this case. And the new action button for updating exchange rate is not yet supported. We will let you know once it’s online.

12

Any update on this? Still waiting for an action button for users to update the exchange rate value on a single sheet

13

It’s in development queue, we will keep you posted in this thread.

14

Still nothing? I need a way for the user to force the update of an exchange rate field on a singe entry.

15

Wait, I see some changes in the design backend that weren’t announced here.

Screen Shot 2023-07-03 at 1.47.35 AM

UPDATE: Unfortunately, in my limited testing I have come across a problem right away. If I check “Fetch exchange rate of selected date” and reference a date field of today, the exchange rate field is left empty. I assume this is due to the fact that my time zone is HK, it’s only 2AM, and the field thinks I am referencing a date that is in the future?

16

The spec of this feature are currently being reviewed. If there are any updates regarding its support or limitations, we will notify you in this discussion thread.

We appreciate your patience as many users have submitted feature requests.

For the aforementioned question, please contact us through support ticket via “Need Help?” so that we could have a look at your current sheet design and conduct further investigation.