Multiply sum of several number fields with another value when checkbox on

Forum|Forum|2 years ago
March 4, 2024
1 reply
667 views

I have a receipt form with many number fields. I need a field "Card Fee" to contain the product of 0.05 by the sum of four other fields when the "Charge" checkbox is ticked. Many times only one of these summed fields ("Parts") will contain a value, which is the sum of several other fields, if that matters.

The breakdown of the equation is:

("Core Due" + "Parts" + "Service" + "Shipping") * 0.05 = "Card Fee"

This topic has been closed for replies.

Correct answer Nesa Nurani

Use this as custom calculation script of "Card Fee" field:

var f1 = Number(this.getField("Core Due").valueAsString);
var f2 = Number(this.getField("Parts").valueAsString);
var f3 = Number(this.getField("Service").valueAsString);
var f4 = Number(this.getField("Shipping").valueAsString);
var check = this.getField("Charge").valueAsString;
var total = (f1+f2+f3+f4)*0.05;

event.value = (check === "Off") ? "" : total;

Nesa Nurani

Correct answer

Community Expert

Use this as custom calculation script of "Card Fee" field:

var f1 = Number(this.getField("Core Due").valueAsString);
var f2 = Number(this.getField("Parts").valueAsString);
var f3 = Number(this.getField("Service").valueAsString);
var f4 = Number(this.getField("Shipping").valueAsString);
var check = this.getField("Charge").valueAsString;
var total = (f1+f2+f3+f4)*0.05;

event.value = (check === "Off") ? "" : total;

D

domazetmotorAuthor

Participant

I copied and pasted and realized my Shipping field is actually named "Total Shipping." I added that to the script, but it still didn't work 😞

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