Highlighted

change currency

Explorer ,
Oct 21, 2020

Copy link to clipboard

Copied

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?

TOPICS
PDF forms

Views

35

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

change currency

Explorer ,
Oct 21, 2020

Copy link to clipboard

Copied

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?

TOPICS
PDF forms

Views

36

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Oct 21, 2020 0
Most Valuable Participant ,
Oct 21, 2020

Copy link to clipboard

Copied

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)...

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 21, 2020 0
Explorer ,
Oct 21, 2020

Copy link to clipboard

Copied

I understand. No worries if value remains same. 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 21, 2020 0
Engaged ,
Oct 21, 2020

Copy link to clipboard

Copied

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);}

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 21, 2020 0