Two (2) columns of expenses in different currencies

I previously built a solution for a similar use case, where I created one field for the amount, another field for the currency, and a third field (a formula or automation agent) that converts the entered amount into USD using the exchange rate at that time (fetched from the internet).

​@milenaT 

Some people accomplish this by writing their own custom JavaScript code, but I don’t know JavaScript.

If you’re like me and you don’t know JavaScript, then you can quickly & easily automate your currency conversions — without using any programming code at all — by using Make’s currency conversions alongside Make’s Airtable integrations.

Make is a no-code automation and integration platform.

Not only does Make have its own built-in currency exchange converter, but you can also connect to ANY currency exchange API on the entire Internet by using Make’s HTTP modules. 

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you can instantly trigger a Make automation from Airtable. 

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hm, you could probably do this with:

1. Number field for USD
2. Number field for USD converted to Euros 
3. Number field for Euros
4. Formula for the ‘Final’ total in Euros
   1. This would show either the converted from USD value if that existed, or the Euro value

The USD conversion to Euros would be handled via an automation that would run a script to help you get the current currency rate and then do the multiplication for you

Should be fairly simple to set up!  I do free half hour calls and reckon we could probably get it done within that time, and you can grab a time here!

If you already have the conversion rates, this is easy to do with a formula, just like in Excel.

If you don't have the conversion rate, as Hamza said, you can write a script to fetch that from the internet. You could use something like this service: https://www.exchangerate-api.com/ 

If you do not want to write a script to fetch the conversion rate, you could ask Omni to write the script for you and see how it does.

If you don't get a good result from Omni, you could try using an AI field agent to fetch the conversion rate from the Internet, or add an AI automation that fetches the current conversion rate when the row is added. But now you have to add time to test that the conversion rate will be accurately fetched, because in my experience AI agents do not always fetch the correct information. 

Hey ​@milenaT!

I played around with this suggestion above.
1. Super fun use case for AI
2. I provided a website from were to get historic FX rates
3. You will want to make sure to ask for either BUY or SELL rate, or even an average. But make sure to include this on your prompt.
4. You will wanto to make sure to take into consideration that usually weekends and holidays do not have an FX rate. Make sure to include a note on your prompt so that if no rate was found for the correspnding date, fetch the immediately previous available rate.
5. Even taking the above into consideration, I was not able to get it to work accurately on 100% of the runs, but it was a great strating point.

Thanks for sharing ​@hamza.as.aslan!

Mike, Consultant @ Automatic Nation 
YouTube Channel  ​​​​​​​

I have some experience with this.

You’ll soon encounter situations were exchange rates fluctuate and you’d need to account for it. The way I’d handle is a automation running a script that pings a free endpoint to get today’s rate, then all txns linked to today are converted using today’s rate. If you have USD filled, it fills the EUR field, and vice versa.

That should be the most business friendly method.

You may use this endpoint to get conversion rates: https://open.er-api.com/v6/latest/USD

and this scripting helper to write the script: https://chatgpt.com/g/g-GuMycukiN-vik-s-scripting-helper

Should be good to use at a once or twice a day cadence. Else rate-limiters will kick in.

It’d take 1-2 hours to set up for me. Ping me for consults if you need help with this or other issues: https://calendly.com/d/dvq-nvm-nhg