I have 2 tables:
- Currency Table
- Orders Table
The Currency Table has a column [Fx Rate] that is generating a currency exchange rate via a google finance API call formula eg: =IFERROR(GoogleFinance(“CURRENCY:”&B2))
The Orders table has a status column that has 13 stages, at one of the status stages i would like to create an action or workflow that copies the (always changing) value from the [Fx Rate] column of the Currency Table and places the current value (at the time the user updates to the relevant status) into the Orders Table [Applied Fx Rate] column
Not sure how other members here are applying currency conversions to their data, any help would be great, just a shove in the general direction will be fine. I don’t think i can simply use an app formula to produce the result, i’ve tried quite a few ways.