Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Help with converting an excel formula into Javascript

Guest
Jul 30, 2019 Jul 30, 2019

I am trying to convert an Excel expression/formcalc script that essentially divides the totals of two fields provided on a PDF form. One field may include a total entered on a another page.  The formcalc script I am currently using works, and is listed below.  Is there any chance someone might be able to help me with converting to javascript?  Thanks so much!

if(Page1.Total_undupl ne 0 & HasValue(Page1.Total_undupl)) then

Total_al_instr / Page1.Total_undupl

else

null

endif

TOPICS
Acrobat SDK and JavaScript , Windows
619
Translate
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

Community Expert , Jul 30, 2019 Jul 30, 2019

You can use something like this:

var v1 = Number(this.getField("Total_al_instr").valueAsString);

var v2 = Number(this.getField("Page1.Total_undupl").valueAsString);

if (v2==0) event.value = "";

else event.value = v1/v2;

Translate
Community Expert ,
Jul 30, 2019 Jul 30, 2019

You can use something like this:

var v1 = Number(this.getField("Total_al_instr").valueAsString);

var v2 = Number(this.getField("Page1.Total_undupl").valueAsString);

if (v2==0) event.value = "";

else event.value = v1/v2;

Translate
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
Guest
Jul 30, 2019 Jul 30, 2019
LATEST

Thank so so much! Appreciate your help.

Translate
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