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

How to Hide Trailing Zeros in a Number / Rounding to Nearest Quarter Hour

Community Beginner ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

I have fields on a PDF form for number of hours. I want to allow for 2 decimal places to allow for quarter hours (15 min, 45 min). This is an example of what is currently being displayed:

4.00

3.25

6.50

Is there a validation script that would hide the trailing zeros? I want the numbers above to be displayed as:

4

3.25

6.5

I've also been looking for a script that would round to the nearest quarter hour (.25, .5, .75), but I haven't had any luck finding this on forums. Is this even possible? It seemed too complicated so I abandoned the idea. I'm a novice when it comes to custom scripts and would appreciate any help from this knowledgeable community.

TOPICS
Acrobat SDK and JavaScript , Windows

Views

813

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

correct answers 1 Correct answer

Community Expert , Feb 21, 2019 Feb 21, 2019

Place the code as a doc-level script and as field's custom validation (or as a part of the calculation) script, enter this:

event.value = roundToNearestQuarter(event.value);

Votes

Translate

Translate
Community Expert ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

This function I wrote will do it:

function roundToNearestQuarter(v) {

    v = (Math.round(v * 4) / 4);

    if (v==Math.round(v)) return v.toFixed(0);

    else return v.toFixed(2);

}

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 Beginner ,
Feb 21, 2019 Feb 21, 2019

Copy link to clipboard

Copied

Thanks for your reply. It wasn't able to get this to work. Could you please advise where I should add this?

Is there a stand-alone code just to get rid of trailing zeros after the decimal? I have use for this on a different form I'm working on.

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 ,
Feb 21, 2019 Feb 21, 2019

Copy link to clipboard

Copied

Place the code as a doc-level script and as field's custom validation (or as a part of the calculation) script, enter this:

event.value = roundToNearestQuarter(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
Community Beginner ,
Feb 21, 2019 Feb 21, 2019

Copy link to clipboard

Copied

Thank you! Works perfectly for rounding to the nearest quarter. Is there anything I can add to get rid of the zeros at the end?

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 ,
Feb 21, 2019 Feb 21, 2019

Copy link to clipboard

Copied

It does that, too.

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 Beginner ,
Feb 21, 2019 Feb 21, 2019

Copy link to clipboard

Copied

I had to change the format of the field from Number to None to get this to work. Anything that rounds to ".5" still displays as ".50", but it works for all whole numbers and quarters. Now if I type something other than a number, it displays "NaN". Is there a way to only allow for a number to be added?

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 ,
Feb 21, 2019 Feb 21, 2019

Copy link to clipboard

Copied

You didn't say anything about removing the zero from "0.50", only full numbers.

And if you want to use this script and have non-numeric values then you'll need to first check if the value can be converted to a number, and if not, not call the function.

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 Beginner ,
Feb 21, 2019 Feb 21, 2019

Copy link to clipboard

Copied

LATEST

In my original post, I gave the example of 6.50 displaying as 6.5.

I don’t want non-numeric values at all, but the function script wouldn‘t work when I formatted the field as a number. I’m not sure how to add the “if” statements you described. Sorry, I’m a newb. I appreciate your patience in helping me through this.

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