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

JavaScript Calculation Help!

New Here ,
Apr 12, 2022 Apr 12, 2022

Greetings! I have no experience with script, but trying to create a custom calculation script in my form to auto calculate QTY * Price Per Case = Extended Price for each row.  

KimmarieE_0-1649817682527.pngexpand image

I found this formula on the Adobe Community, which works, but it also populates the Price Per Case and Extended Price from Row 1 on the rest of the rows. They should be blank until I fill in QTY and Price Per Case.

var firstValue = this.getField("Price Per CaseRow1").valueAsString;

var secondValue = this.getField("QTYRow1").valueAsString;

if (firstValue=="" || secondValue=="") event.value = "";

else event.value = Number(firstValue) * Number(secondValue);

 

KimmarieE_1-1649817682533.pngexpand image

Please help!

205
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
Community Expert ,
Apr 12, 2022 Apr 12, 2022

You are exposing only some of the event handlers associated with the Price Per Case field.
Only the Price Per Case field can be rewritten and controlled here.
The code you have should also contain event handlers for the Extended Price field, so you need to expose that to lead to a solution.

...Maybe.

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
New Here ,
Apr 12, 2022 Apr 12, 2022

Thanks for the quick reply! Not sure how to add the additional handlers in JavaScript. 🙂  

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
Community Expert ,
Apr 12, 2022 Apr 12, 2022
LATEST

Is it difficult to post all the codes?  of course, confidentiality is a consideration.

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