Forum Discussion

EHEH's avatar
EHEH
Qrew Cadet
7 years ago

Convert currencies to USD using today's exchange rate

Is it possible in QuickBase to convert different currencies to USD using today's exchange rate?

I have a field where users enter costs in different currencies, but want these costs to be converted to USD so i can compare costs. 

I know i can do that by create another numeric field and set us a formula with another text field contains all the currencies and then identify all the foreign currencies values against USD, but this needs to be updated regularly as the exchange rates change. Any function in QB to resolve this and convert currencies to USD based on today's rate. 
Tables and fields

2 Replies

  • Denin's avatar
    Denin
    Qrew Officer
    6 minutes ago

    I do something similar in an app. You need to have a source for the rates and use a Pipeline to send that information from the source via their API to a Quickbase table (each day's rate is a new record in the table). Then you use a formula query to get the latest rate and you can use your subsequent formulas to compare/etc.

  • PaulTIKI's avatar
    PaulTIKI
    Qrew Trainee
    1 hour ago

    I have a similar problem and would love to see a solution.