Currency Conversion

I have two data tables in my application Cost Data and FX Data. The FX Data table contains the fields Currency Name and FX Rate. On a grid view for Cost Data I want to put a dropdown control to display Currency Name and depending on what value is selected it would then multiple the results in the grid by the value of the FX Rate. Therefore giving me multi currency on a single view that would be dynamic as FX rates are updated.

Anyone know how I can achieve this?

Hi @euan !

Welcome to the Knack community, and thank you for sharing! My suggestion to receive help on building out this goal is to schedule some time with our onboarding team here. They will be happy to assist you with this and allow you to ask questions as well.

You can schedule some with us here: Office Hours

You can also reach out to a Knack expert if you find that your app building goals require more advanced building techniques. Here is a link to our Expert Network: Knack Experts Network

Happy building, and have a great rest of your week!