Skip to main content
Participant
April 8, 2022
Question

calculate result triggered by selected fields

  • April 8, 2022
  • 2 replies
  • 1060 views

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 ?

 

 

 

This topic has been closed for replies.

2 replies

Participant
April 8, 2022

Last thing. I need to limit the "result" to be no higher than 180

try67
Community Expert
Community Expert
April 8, 2022

What should happen if they fill in both the "kg" and the "lbs" fields?

Participant
April 8, 2022

@try67 

 

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)

try67
Community Expert
Community Expert
April 8, 2022

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 ]