Copy link to clipboard
Copied
Hi, I need to calculate a result in PDF form. I have 5 fields: kg, lbs, result, quantity and ml.
The formula for result is event.value = Number(this.getField("kg").valueAsString) * 1.8;
> for this formula the user could enter a value in either "kg" or "lbs"
If the user enters the value in "kg", I want the "lbs" to automatically populate and vice versa.
calculation is "lbs = kg * 2.2" or "kg = lbs / 2.2"
The formula for quantity is event.value = Number(this.getField("result").valueAsString) / 50;
The formula for ml is event.value = Number(this.getField("result").valueAsString) / 5;
How can I make this ?
Copy link to clipboard
Copied
What should happen if they fill in both the "kg" and the "lbs" fields?
Copy link to clipboard
Copied
if I enter 50kg the lbs field should show 88.
If I change 88 to 110 in lbs the kg field should update to 50, etc. (based on the calculation)
Copy link to clipboard
Copied
As the custom Validation script of "kg" enter this:
this.getField("lbs").value = (event.value) ? event.value * 2.20462 : "";
And as the custom Validation script of "lbs" enter this:
this.getField("kg").value = (event.value) ? event.value * 0.453592 : "";
[Edited: values were reversed. Thanks, @Nesa Nurani ]
Copy link to clipboard
Copied
@try67 Ok for these that works, but what would be the script for the "result' field to pick either "kg" or "lbs" ?
Copy link to clipboard
Copied
It doesn't matter, since the values will both be the same. Just choose one and use it.
Copy link to clipboard
Copied
2.20462 should go in "kg" and 0.453592 should go in "lbs".
Copy link to clipboard
Copied
Sorry, yes, will fix now...
Copy link to clipboard
Copied
last thing. I need to limit the "result" to be no higher than 180
Copy link to clipboard
Copied
Add this to the end of your calculation script:
event.value = Math.min(180, event.value);
Copy link to clipboard
Copied
Last thing. I need to limit the "result" to be no higher than 180