Conditional formatting for number field - either 2 or 4 decimal places

Question

I have an Adobe form on which I would like the format of a field (“Recommended salary”) to be set to either 2 or 4 decimal places, depending on the value in another field (“FLSA Status”). If “FLSA Status = Exempt, I would like the format to be 2 decimal places and if “FLSA Status” = Non-exempt, I would like the format to be 4 decimal places.

Can anyone help me with the code for this? Also, what would I select as the format category for the “Recommended salary” field – Number? Ideally, the user would input something like this - $58,550.75 or $17.5214 depending on the FLSA Status.

Nesa Nurani · Accepted Answer

Under 'Format' select 'Custom' and then as 'Custom format script' use this:

var status = this.getField("FLSA Status").valueAsString;
if(status == "Exempt")
event.value = util.printf("$%,0.2f",event.value);
else if(status == "Non-exempt")
event.value = util.printf("$%,0.4f",event.value);

Patricia5CAD · Answer

Hoping you can help me again. Management changed the FLSA Status field from a drop down to a radio button (2 choices - Exempt and Non-exempt. If the user doesn't select either option, they should not be able to enter any value into the Recommended Salary field at all. They would also like the numbers entered by the user to be truncated to 2 or 4 decimals instead of rounding. Would you be able to help me with the code for that? Thank you in advance.

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