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

Adobe Form Fields

New Here ,
Jan 13, 2025 Jan 13, 2025

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
266
Translate
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
Translate
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

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

 

Translate
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
LATEST

That's perfect. Thank you so much!

Translate
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