• calculate result triggered by selected fields

# calculate result triggered by selected fields

Community Beginner ,
Apr 08, 2022 Apr 08, 2022

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 ?

TOPICS
PDF forms

Views

148

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
10 Replies 10
Apr 08, 2022 Apr 08, 2022

Copied

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

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Apr 08, 2022 Apr 08, 2022

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)

Likes

Report

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

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 ]

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Apr 08, 2022 Apr 08, 2022

Copied

@try67 Ok for these that works, but what would be the script for the "result' field to pick either "kg" or "lbs" ?

Likes

Report

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

Copied

It doesn't matter, since the values will both be the same. Just choose one and use it.

Likes

Report

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

Copied

2.20462 should go in "kg" and 0.453592 should go in "lbs".

Likes

Report

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

Copied

Sorry, yes, will fix now...

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Apr 08, 2022 Apr 08, 2022

Copied

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

Likes

Report

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

Copied

LATEST

event.value = Math.min(180, event.value);

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Apr 08, 2022 Apr 08, 2022

Copied

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

Likes

Report

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