Excel import functionality

0
Hi, I  have a request entity. It has 2 attributes currency and conversion factor. The value of conversion factor is dependent on the selection of currency. The values of currency and their respective conversion factor has been provided in an excel sheet. Can someone please guide me how to import these values and show the currency in a dropdown?     Thanks.
asked
1 answers
0

Hi Anusha,

First of all you should use the excel importer module to import the currency and the conversion rates. 

https://marketplace.mendix.com/link/component/72

Follow the documentation on setting this up to import the excel.

 

Then you should save your currencies and conversionfactor in a different entity. The request should be associated with a currency. This allows you to select a currency using a reference selector and then accessing the conversion factor.

Hope this helps!

answered