Convert Application table data using FxRates

Hi, I have an Application table containing a number of attribute columns, a currency column (EUR,USD,TRY...) and an Amount column. The client wants a twin table that has all rows from the table 1, but with all values converted to euros.

I already have a dashboard that shows table 1 with a button to refresh its content (pulling data from other Application tables).

What is the best way of refresh table 2? I was thinking of creating an extensible rule to update table 2 on demand, but I have noticed I cannot use the api.fxrates in there...

Thank you