change currency

[arshadsolehry]

I have a invoice with sum calculations. The values are formatted as $ numbers. But the problem is currency is not always $. Is this possible if we have a drop down for currency calculation and it auto change currency in all fields based on drop down?

[try67]

Yes, it's possible, but requires development of a custom-made script. Also, this will not convert the values, so if you change it from USD to EURO (for example), then 10 USD will become 10 EUROS, not 8.44 EUROS (according to today's exchange rate)...

[arshadsolehry]

I understand. No worries if value remains same. 

[Nesa Nurani]

You didn't say what are items in your dropdown, I'm assume you mean something like $, € and £ (you can adapt code yourself) use code as custom format script of your calculate field.

var drop = this.getField("Dropdown1").valueAsString;
if(drop == "£"){AFNumber_Format(2, 0, 0, 0, "£", true);}
else if(drop == "$"){AFNumber_Format(2, 0, 0, 0, "$", true);}
else if(drop == "€"){AFNumber_Format(2, 0, 0, 0, "€", true);}