What this tool does
The Currency Converter reads a numeric amount from an Airtable field and converts it to one or more target currencies. Converted values are written to Airtable fields (which the tool can create automatically).Settings reference
Source
| Setting | Description |
|---|---|
| Source table | The table containing currency amounts. |
| Amount field | The Number, Currency, Percent, or Formula field containing the amount to convert. |
Source currency
| Setting | Description |
|---|---|
| Source currency | Fixed (same for all records) or From field (per-record). |
| Currency code | The fixed currency code (e.g., USD). Only shown when Source currency is Fixed. |
| Currency field | A Single Select or Single Line Text field containing the currency code per record. Only shown when Source currency is From field. |
Target currencies
| Setting | Description |
|---|---|
| Target currencies | Select one or more currencies to convert to. A separate output field is created or mapped for each. |
Field naming
| Setting | Description |
|---|---|
| Field naming pattern | How auto-created output fields are named. Options: {field} ({currency}), {field} in {currency}, or {currency} {field}. |
| Decimal places | Precision for converted values: 0, 1, 2 (default), 3, or 4 decimal places. |
Handling
| Setting | Description |
|---|---|
| Skip empty fields | Skip records with blank amount or currency fields. |
| Overwrite existing values | Re-convert records that already have values in output fields. |
Supported currencies
USD, EUR, GBP, JPY, CHF, CAD, AUD, CNY, INR, BRL, MXN, KRW, SEK, NOK, DKK, PLN, TRY, ZAR, SGD, HKD, NZD, THBHow output fields work
For each target currency you select, the tool writes to a corresponding field. If the field doesn’t exist yet, the tool can create it automatically using the naming pattern you configure. Example: Amount field is “Price” and you convert to EUR and GBP with the{field} ({currency}) pattern. The tool writes to:
Price (EUR)Price (GBP)
Exchange rates
Exchange rates are fetched at the time the run starts. All records in a single run use the same rates. For the most current rates, run the tool when you need up-to-date conversions.Common questions
How current are the exchange rates?
How current are the exchange rates?
Exchange rates are fetched from a live exchange rate API at the start of each run. They reflect market rates at that moment.
Can I convert from a different source currency per record?
Can I convert from a different source currency per record?
Yes. Set Source currency to From field and map a field that contains the ISO 4217 currency code for each record (e.g.,
USD, EUR).What happens if the source currency code in the field doesn't match a supported currency?
What happens if the source currency code in the field doesn't match a supported currency?
That record is skipped with an error in the execution log.