Mar 27, 2020 10:27 PM
I don’t seem to understand Airtable.
I would like to have a Table of Transactions as follows:
In addition, I have exchange rates between my business currency (HKD) and other currencies, by year: one set of exchange rate for 2019, one for 2020, in the future for 2021, 2022, etc.
I would like to have a table that contains the exchange rates for each year, for example like this:
Finally, the RateForthisTx Field in the Transaction Table should be the result of a lookup(Currency, Year), e.g., lookup(AUD, 2019), or lookup (CHF, 2020), whatever corresponds to the actual values in a given transaction.
I must be thick, but I can’t find a solution Airtable, unless, perhaps, we’d have to resort to Scripts.
Once again, a big thank you to anyone who can help.
Mar 28, 2020 11:30 PM
You can do the following,
In the ExchangeRates table, copy the Primary Field into another field. (insert a new field and copy it)
Now in the Primary Field, Make a formula that is
In the Transactions table, creat a Linked Field that links to the Exchange Rates (you can do this manually or via script, look in the community for scripts for linked records).
Now you can do your lookup.
Mar 29, 2020 12:37 AM
thanks again very much. Will try it!
Sep 24, 2021 08:57 AM
@Peter_Schindler Unless I am mistaken, the app we have built, Currency Converter (Currency Converter - Apps - Airtable Marketplace) may be a help if this is still a problem. We are constantly looking for ways we may improve it so let us know if there is something missing :slightly_smiling_face: