How to format a integer fields to Currency?

Question

The requirement is like, Users will enter their salary, no alpa, just numbers. After finishing type, the numbers converted to currency formatting.

E.g. 1234 --> $1,234.00

Can someone help on the script on the data transformer and also need to limit user enter any other charactors but only numbers.

Note: the Salary Field is a String field.

This is where I got so far, but it doesn't work..

var salaryScript = "";
salaryScript = "var salary = getField("Salary");";
salaryScript += "var salaryEntered = salary.value;";
salaryScript += "var currency = '$' + parseFloat(salaryEntered).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,');";
salaryScript += "salary.value = currency;";

var salaryField = getField("Salary");
salaryField.setAction("OnBlur", salaryScript );

try67 · Accepted Answer

Correct it -- No, we are NOT allowed do any modify on the Acorbat. All the work need to be done on the 3rd part design tool, then genereate a correct PDF Form for customer to use.This is all you need: var salaryField = this.getField("Salary");salaryField.setAction("Format", "event.value = util.printf(\"$%,0.2f\",event.value);");

Thom Parker · Answer

Your script is way over complicated and problematic. Do not use it.

Why not use the built-in currency number formatting instead?

The alternative is to use a custom format script.

Like this:

event.value = util.printf("$%,0.2f",event.value);

You should learn a bit about how field event work in Acrobat Specifically Format events.

Here's an article on the topic:

https://www.pdfscripting.com/public/Formatting-Form-Fields.cfm

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