How to Manage Multiple Currencies in a Single Airtable Base

If you are tracking a stock or options portfolio in Airtable, you may want to manage values in dollars, euros, and Swiss francs inside the same base.

Then you realize Airtable only lets you set one currency symbol per field.

So it can feel like the only option is to concatenate everything as text just to show whether the amount is $, €, or CHF.

But if the goal is not to convert the currencies and only to keep the figures separated, there is a much simpler solution.

Change the currency symbol in the field settings

In each Airtable currency field, you can set the Currency symbol manually.

You can use $, €, CHF, or even labels like USD, EUR, and GBP.

So you can simply create separate fields such as Amount USD, Amount EUR, and Amount CHF, and assign the right symbol or label to each one.

This way, each value keeps its own currency and you do not have to turn the result into text.

If you want exchange rates later

If later you decide that you do want conversion, then you can build that on top of the same structure.

The cleanest way is to keep your separate currency fields and add another field for the converted value.

Then use an automation tool such as Make to call an exchange rate API whenever a record is created or updated.

In that scenario, the automation checks which currency field has a value, sends that amount and currency to the API, retrieves the latest exchange rate, and writes the converted result back into Airtable.

You can also add your own logic before saving the result. For example, you may want to apply a fixed margin, a commission, or use a custom rate instead of the raw market rate.

This gives you the best of both setups. You can keep the original amount in its own currency field, and at the same time store a converted amount for reporting when needed.

But if your goal is only to know whether the figure is in dollars, euros, or francs, and not to convert it, then just changing the currency symbol in each field is enough.