Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


Math Calculation Help

Community Beginner ,
Sep 10, 2021 Sep 10, 2021

Copy link to clipboard

Copied

Hello,

 

I've been having trouble making certain calculations work. I was working on this form a few months ago, and thought this particular calculation was working, but it's not now, and I can't figure out what's wrong with it. When I compare it to other fields with similar expressions that do work, I can't see the difference. Perhaps "new eyes" will help.

 

var f = Math.ceil(this.getField("1 - Total Output Current" + "2 - Total Output Current" + "3 - Total Output Current").value / 5) * 5;

event.value = util.printf("%.0f", f);

TOPICS
Create PDFs, General troubleshooting, How to, JavaScript, PDF forms

Views

30

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
community guidelines

correct answers 1 Correct answer

Adobe Community Professional , Sep 10, 2021 Sep 10, 2021
Try it like this: var a = Number(this.getField("1 - Total Output Current").valueAsString); var b = Number(this.getField("2 - Total Output Current").valueAsString); var c = Number(this.getField("3 - Total Output Current").valueAsString); var x = Math.ceil((a+b+c)/5)*5; event.value = util.printf("%.0f", x);

Likes

Translate

Translate
Adobe Community Professional ,
Sep 10, 2021 Sep 10, 2021

Copy link to clipboard

Copied

Try it like this:

var a = Number(this.getField("1 - Total Output Current").valueAsString);
var b = Number(this.getField("2 - Total Output Current").valueAsString);
var c = Number(this.getField("3 - Total Output Current").valueAsString);
var x = Math.ceil((a+b+c)/5)*5;
event.value = util.printf("%.0f", x);

 

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
community guidelines
Community Beginner ,
Sep 10, 2021 Sep 10, 2021

Copy link to clipboard

Copied

That worked perfect! I think I got the original script from try67, and he seems to create extremely succinct scripts. Was there anything wrong with what I had, or is Acrobat just finicky?

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
community guidelines
Adobe Community Professional ,
Sep 10, 2021 Sep 10, 2021

Copy link to clipboard

Copied

Following is wrong:

this.getField("1 - Total Output Current" + "2 - Total Output Current" + "3 - Total Output Current").value

 

You must use getField for every field.

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
community guidelines
Community Beginner ,
Sep 10, 2021 Sep 10, 2021

Copy link to clipboard

Copied

LATEST

Ok, I see. Thank you both Bernd and Nesa!

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
community guidelines