Currency Updater application will need to use 5 fields to show the proper converted amount.
- Amount field (Currency or Number type): used to calculate the converted amount
- CurrencyISOCode: used to look the proper Dated Conversion Rate
- Date field (Date Type): used to look the proper Dated Conversion Rate
- Dated Exchange Rate (Number Type): Where the app will populate with the conversion rate for the currency and date. Ensure to grant permissions all users creating or updating records.
- Converted Amount (Formula field) like the image below
