Capping Sum of Fields in a Form

Question

I have a form that has 27 different fields that have $$ amounts in them.     I need to add them all up to create a sum,  but if the sum exceeds $5000, I need it to only show $5000 - no higher.    I've tried many different forums and suggestions online, but can't seem to knock this one out.  This is literally the last field I need for this document.  Can anyone assist?

Nesa Nurani · Accepted Answer

There is an easier way to achieve this, use built in 'sum' option in the total field, under 'calculate' tab select 'Value is the' leave as sum(+) and pick your fields, in 'Validate' tab enter this script:
if(Number(event.value) > 5000)event.value = 5000;

PDF Automation Station · Answer

Create a custom calculation script like this:

var total=

Number(this.getField("Field1").valueAsString)+

Number(this.getField("Field2").valueAsString)+

Number(this.getField("Field3").valueAsString)+

Number(this.getField("Field4").valueAsString)...etc.

if(total > 5000)

{event.value=5000}

else

{event.value=total}

If you're fields have a specific consistent naming convention with numbers, you might be able to avoid typing out every field name into the script.

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