Adobe Form Fields

Question

Hello! I have a PDF that pulls info into it using form fields. Is there a way to split a whole dollar amount into millions, thousands and hundreds using a formula? Say the field name is bondamount

thanks and appreciate any help

Nesa Nurani · Answer

You want to show each in a different field?

EDIT:
You can use a script like this in each field as custom calculation script:
For millions:

var bondamount = Number(this.getField("bondamount").valueAsString);

if (bondamount != 0) {
 event.value = Math.floor(bondamount / 1000000);} 
else {
 event.value = "";}

For thousands:

var bondamount = Number(this.getField("bondamount").valueAsString);

if (bondamount != 0) {
 event.value = Math.floor((bondamount % 1000000) / 1000);} 
else {
 event.value = "";}

For hundreds:

var bondamount = Number(this.getField("bondamount").valueAsString);

if (bondamount != 0) {
 event.value = Math.floor(bondamount % 1000);} 
else {
 event.value = "";}

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