Adobe Pro DC simple question.

Question

Hi all,I am new to Adobe Acrobat DC, and I am sure this is something simple, but I have very little JavaScript "know-how."  I am working on something for work and I am looking to use some sort of conditional formula.  Below is a brief description of what I am trying to do:I have a form and I would like to sum up a range of text boxes across, but only if the first text box is not empty.  (i.e.  Text Box 1 has the date in it, so now I would like Text Boxes 2-10 to sum up in Text Box 11)I mostly work with Excel, and as I said I am somewhat new to scripting so any help would be greatly appreciated. Also, if anyone has any suggestions for resources I could use to learn more about JavaScript and its uses within Adobe Acrobat DC.Thanks all,

try67 · Accepted Answer

You can use something like this as the custom calculation script of "Text Box 11":

if (this.getField("Text Box 1").valueAsString=="") event.value = "";
else {
    var total = 0;
    for (var i=2; i<=10; i++)
          total+=Number(this.getField("Text Box "+i).value);
    event.value = total;
}

JoelGeraci_Datalogics · Answer

The pdfscripting.com site is, in my opinion, the best resource for learning Acrobat JavaScript. Much of it is free, certainly enough to get you started is free, and when you get into the advanced stuff, the membership area will save you a lot of time not reinventing the wheel. I've been programming in Acrobat JavaScript for over a decade and I still refer to pdfscripting.com for some stuff.

J-

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