Objective
This article describes the detailed steps on how to implement currency conversion with the exchange rates from SharePoint List or SQL database or from open exchange rates API (ex: http://fixer.io JSON API) in NINTEX Forms.
Approach
For this demo, I have chosen USD as the output currency that I would like to convert to the amount entered based on the currency chosen. You can make output currency configurable by adding one more currency choice field.
Configuration in NINTEX form
Controls
- Add a Textbox to enter the amount.
- Add a Choice Control to select the currency. Here, I am using currency codes in the choices, few codes shown below.
- USD
- INR
- EUR
- GBP
- MXN
- Add any of the following controls based on your need to fetch the exchange rate.
- Web Request control to fetch the conversion rate from an open API.
- SQL control to fetch the conversion rate from SQL database.
- Calculated field to fetch the conversion rate from SharePoint List.
- Add calculated field to perform currency conversion.
Control Configuration
Web Request
Configure the control, as shown below in the screenshot.
the control. Thus, just, copy the 
Join the conversation! Your thoughts help the community grow.