Calculating Participation Rates

[Vijay_chen]

How to automatically obtain the daily exchange rate and add the corresponding record in the specified table.

[ScottWorld · Accepted solution]

Check out my post here on currency exchange rates & currency conversion:

Formula field that also takes input Formulas

You would need to find both: A currency conversion API and A way of programmatically writing the rates to your base. The easiest way might be to use Make, which doesn’t require any coding knowledge and comes with its own native currency converter based on the European Central Bank exchange rates: Otherwise, you will need to find your own currency converting API on the Internet that you want to use, and then you would need to program it into your base by using the DataFetcher.com extension…

[Vijay_chen]

Thank you for such a quick and accurate reply :laughing: