Custom calculation to sum or allow text

Question

I'm creating a form and would like to have a field that either calculates the sum of three previous fields, or allows the user to type text. Specifically, each row has breakfast, lunch, dinner, and total fields. In the total field I would like the sum of breakfast, lunch, and dinner OR allow the user to type an amount. I'm modeling off an old form that has the below in the custom calculation script. It works on the old form, but not the new one. The new form doesn't sum the fields and only allows text entry. Help please 🙂

var B = this.getField("BREAKFASTRow1").value;

if(B>0) event.vaule = Calcs();

var L = this.getField("LUNCHRow1").value;

if(L>0) event.vaule = Calcs();

var D = this.getField("DINNERRow1").value;

if(D>0) event.vaule = Calcs();

Nesa Nurani · Accepted Answer

I guess either works. If any field has an amount entered, I would like the sum entered in the "total" field, however if no amounts are entered, I would like the "total" field to be "unlocked" in a sense so any amount can be entered by the user. Hopefully that makes sense. I appreciate your help.

Try this:

var a = Number(this.getField("BREAKFASTRow1").valueAsString);
var b = Number(this.getField("LUNCHRow1").valueAsString);
var c = Number(this.getField("DINNERRow1").valueAsString);

if(a || b || c)
event.value = a+b+c;

try67 · Answer

Where is the definition of the Calcs function?

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