Live Currency Conversion Rates

[Ja_ke]

Is there a way to get live (or updated daily, or even weekly) currency conversion rates into the app? With the rate the math would be easy to do, but how to get them in there in the first place?

I tried using a google sheet with the googlefinance function but it doesnt recognize the formulas unfortunately.

I have to assume there is some native way to do this, but havent found anything written anywhere.

I found a video that Jeff had linked in another forum post, but that person was using a glide table with a value written in that i imagine he was manually updating?

Any tips?

[Jeff_Hager]

@Ja_ke

I tried using a google sheet with the googlefinance function but it doesnt recognize the formulas unfortunately.

Can you explain how you tried to do this? The formula would need to be entered in the google sheet. Not the through glide.

@Ja_ke

video that Jeff had linked in another forum

Can you provide a link to that post?

@Ja_ke

I have to assume there is some native way to do this, but havent found anything written anywhere

The native way would be to call an API to retrieve current rates from some kind of public API.

[Ja_ke]

@Jeff_Hager

Can you explain how you tried to do this? The formula would need to be entered in the google sheet. Not the through glide.

Yes i created a google sheet, put the googlefinance function in (and it showed correctly in the sheet), but when i linked the sheet to glide it only showed column headers and where the rate should have been it showed a blank cell.

@Jeff_Hager

Can you provide a link to that post?

Currency conversion

Dear Comumunity: I need help whit this: I have in my table a list of products which have a price for each row. How I can automatically convert the price to a specific currency without having to write that value in each row each time it is updated.

Here is the post. It was actually not you who linked the video, but responded to it. My Apologies.

@Jeff_Hager

The native way would be to call an API to retrieve current rates from some kind of public API.

Ok, I will learn to use API calls then it seems. thanks!

[ThinhDinh]

The nature of the “currency conversion” might consume a lot of updates if you want up-to-the-minute rates.

Free Currency Conversion and Forex Exchange Rate API

Something like this claims to offer 1000 API calls/month for free, maybe you can start experimenting with it.

[Ja_ke]

@ThinhDinh

The nature of the “currency conversion” might consume a lot of updates if you want up-to-the-minute rates.

Yes this was one of my main concerns, and the google sheet syntax includes a refresh rate that you can specify as Daily which was perfect for me.

I am looking at the possibility of triggering an API call to update currency rates when a button is pressed in the app, or on a scheduled time via workflow.

I have not used API calls before though so not sure what is or is not possible yet.

[ThinhDinh]

I’m not sure how well it works, but the Call API column offers a “refresh after” param that you might be able to use.

Button that calls a workflow should work too, and if you have access to scheduled workflows, that might work better for your use case since you know exactly how many updates you would consume.