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

Adobe Form Fields

New Here ,
Jan 13, 2025 Jan 13, 2025

Copy link to clipboard

Copied

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

TOPICS
PDF , PDF forms

Views

69

Translate

Translate

Report

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 ,
Jan 13, 2025 Jan 13, 2025

Copy link to clipboard

Copied

Votes

Translate

Translate

Report

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 ,
Jan 13, 2025 Jan 13, 2025

Copy link to clipboard

Copied

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 = "";}

 

Votes

Translate

Translate

Report

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 ,
Jan 13, 2025 Jan 13, 2025

Copy link to clipboard

Copied

LATEST

That's perfect. Thank you so much!

Votes

Translate

Translate

Report

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