Known Participant

Question

Currency Converter java script in pdf form

Forum|Forum|7 years ago
July 18, 2018
6 replies
1620 views

Hello, how can I calculate currency in pdf forms?

This topic has been closed for replies.

Legend

I think the sample posted is designed to do this. Put it on field 10, and change the field names in the first 2 lines to be the field names for fields 9 and 2.

T

tanerz18448860Author

Known Participant

Okay, but if I am in this situation:

The country is Germany in field 0.
The value in field 1 is 35.
The currency in field 2 is EUR.

field 6 is day counter, if I put 18/07/2018 start date in field 4 and 19/07/2018 end date in field 5, my counter is with value 3 in field 6.

Now day counter value * 35 calculation in field 9 the value is 105

in field 10 I want to convert this value from EUR to BGN.

T

tanerz18448860Author

Known Participant

No, in field 2 the type of currency is change automatically when change country from drop down field 0.
If the country is USA the type of currency in field 2 will be USD if the country in drop down field 0 is Germany the currensy type in field 2 will be EUR.

try67

Community Expert

Then you can use the export value of the Country drop-down field...

Otherwise you can just hard code it into a calculation script, like this:

var curr = this.getField("Currency").value;
var price = Number(this.getField("Price").value);
if (curr=="USD") event.value = price * 1.24;
else if (curr=="EUR") event.value = price * 0.82;
else if (curr=="GBP") event.value = price * 0.7; // etc.
else if (curr=="BGN") event.value = price;

T

tanerz18448860Author

Known Participant

Yes I want to do it with fixed rate for the conversion.

But the formula?

And the structure of script in pdf forms?

I want to check two fields in pdf forms for values and their currency ID.
For example field 1 is for value, field 2 is for currency type of field 1.

I want to check these fields for calculate currency in field 25 where I need the value calculated in BGN.

My currensies are 7.
USD
AUD
EUR
GBP
CHF
JPY
BGN

The possibilities in field 2 and 4 are 6: USD, AUD, EUR, GBP, CHF, JPY.
I want to check field 2 for the currency, if the currency is USD, then use the value from field 1 and calculate it with formula for USD to BGN in field 25 , with the value from field 1.

I need only one example how can I do it for USA to BGN.

And example how to switch to another formula for example if in field 2 the currency is not USD, it is EUR, then I want to calculate EUR to BGN. ??

try67

Community Expert

Do you have a drop-down field for the currencies? If so, then apply the rate as the export value of each item, and then simply using the Product option under the Calculate tab. Multiply the value by the rate, and you'll get the result.

T

tanerz18448860Author

Known Participant

Yes I want to do it with fixed rate for the conversion.

But the formula?

And the structure of script in pdf forms?

I want to check four fields in pdf forms for values and their currency ID.
For example field 1 is for value, field 2 is for currency type of field 1.

I want to check these fields for calculate currency in field 25 where I need the value calculated in BGN.

My currensies are 7.
USD
AUD
EUR
GBP
CHF
JPY
BGN

The possibilities in field 2 and 4 are 6: USD, AUD, EUR, GBP, CHF, JPY.
I want to check field 2 for the currency, if the currency is USD, then use the value from field 1 and calculate it with formula for USD to BGN in field 25 , with the value from field 1.

I need only one example how can I do it for USA to BGN.

And example how to switch to another formula for example if in field 2 the currency is not USD, it is EUR, then I want to calculate EUR to BGN. ??

try67

Community Expert

Just like you would calculate any other mathematical formula... If you want further help you need to provide more details.

try67

Community Expert

Oh, if you mean that you want to convert from one currency to another, that's only possible if you use a fixed rate for the conversion.

Getting the rate from an external source, like a web-page, is extremely complicated.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded