Highlighted

How do I set a form field to accept leading zeros in a number?

New Here ,
Aug 27, 2018

Copy link to clipboard

Copied

I am trying to create a fillable form using Acrobat Pro DC 2018 for Mac. One of the fields asks for the employee number. Some begin with zero, but after entering the number and saving the form, the leading zero doesn't show up.

Adobe Community Professional
Correct answer by Bernd Alheit | Adobe Community Professional

Set the format to None.

Views

1.7K

Likes

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

How do I set a form field to accept leading zeros in a number?

New Here ,
Aug 27, 2018

Copy link to clipboard

Copied

I am trying to create a fillable form using Acrobat Pro DC 2018 for Mac. One of the fields asks for the employee number. Some begin with zero, but after entering the number and saving the form, the leading zero doesn't show up.

Adobe Community Professional
Correct answer by Bernd Alheit | Adobe Community Professional

Set the format to None.

Views

1.7K

Likes

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
Adobe Community Professional ,
Aug 27, 2018

Copy link to clipboard

Copied

Set the format to None.

Likes

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
Reply
Loading...
New Here ,
Jan 23, 2020

Copy link to clipboard

Copied

Sir,

Setting the format to None, the field will also accept alphabets, and then it is not an 'only number' field. The leading zero has to be displayed in Number field alone. In some of the very earlier versions of Excel, it was easy to choose Number format to 'display' or 'do not display' leading zeros.

R G Kulkarni

Likes

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
Reply
Loading...
Most Valuable Participant ,
Jan 24, 2020

Copy link to clipboard

Copied

PDF and Excel are very different things. If you want the field to only accept numbers, but still allow initial zeros, use the following code as its custom Keystroke script (under Properties - Format - Custom):

 

if (event.change) event.rc = /^\d+$/.test(event.change);

 

Note that using this code you won't be able to enter the negative symbol, or a comma, etc. Only digits.

Likes

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
Reply
Loading...
New Here ,
Jan 24, 2020

Copy link to clipboard

Copied

Sir,
Greatly honoured to get so fast a reply. The code has worked and I am able
to get the leading zero being displayed in the 'Number' only field.
Thanks and regards,
Saibai40

 

[Private info removed]

Likes

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
Reply
Loading...
New Here ,
Feb 03, 2020

Copy link to clipboard

Copied

I am very new to applying script to Adobe Acrobat Pro 2017  PDF forms. I have a form where I concatnate two fields (WBSProgram & WBSJobcode) into a third (labeled CompleteWBS) for Work Breakdown Structure (WBS) cost accounting codes. A WBS is alphanumeric, can start with a 0 that must be displayed in the final field.

 

My problem is my final field (CompleteWBS) does not show the 0 in the WBS if it starts with a 0.


this is a correct WBS 

RA.02148956.0123456

my current field would populate this

RA.2148956.23456

 

Is there a script I can apply to still allow letters and also keep leading 0?

Likes

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
Reply
Loading...
New Here ,
Feb 03, 2020

Copy link to clipboard

Copied

Correction, There are three fields that concatnate into the fourth CompleteWBS. The first is the WBSType 

 

in the above WBS example, the RA is the WBSType

Likes

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
Reply
Loading...
Adobe Community Professional ,
Feb 03, 2020

Copy link to clipboard

Copied

What script does you use?

Likes

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
Reply
Loading...
New Here ,
Feb 04, 2020

Copy link to clipboard

Copied

I have three fields (WBSType, WBSProgram and WBSJobCode) that accept user
entry: The WBSType is a dropdown box with options to choose from, the
WBSProgram and WBSJobCode are text fields

I am using JavaScript on blur for the three and javascript. Below are my
script for each field:

*FBMSProjectType -(referenced above as WBSType)*











*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode1"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS1");collatePreSetFieldsTo(five);*










*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode2"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS2");collatePreSetFieldsTo(five);*










*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode3"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS3");collatePreSetFieldsTo(five);*










*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode4"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS4");collatePreSetFieldsTo(five);*


*WBSProgram*











*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode1"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS1");collatePreSetFieldsTo(five);*










*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode2"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS2");collatePreSetFieldsTo(five);*




























































*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode3"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS3");collatePreSetFieldsTo(five);//this function
popluates the referenced field.function collatePreSetFieldsTo(populate){
//always overwrite the value in populate field with these field values var
one = this.getField("FBMSProjectType"); var two =
this.getField("WBSProgram"); var three = this.getField("WBSJobCode4");
//concatenate populate.value = one.value + '.' + two.value + '.' +
three.value ;}var five =
this.getField("CompleteWBS4");collatePreSetFieldsTo(five);WBSJobCode1 - My
form allows up to 4 unique WBSJobCodes. Each has the script below but
different WBSJobCode2, WBSJobCode3, WBSJobCode4//this function popluates
the referenced field.function collatePreSetFieldsTo(populate){ //always
overwrite the value in populate field with these field values var one =
this.getField("FBMSProjectType"); var two = this.getField("WBSProgram");
var three = this.getField("WBSJobCode1"); //concatenate populate.value =
one.value + '.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS1");collatePreSetFieldsTo(five);My final field
where all these concatenate too is labeled CompleteWBS and is Run
JavaScript On Focus//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode1"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS1");collatePreSetFieldsTo(five);I also have a
Custom Calculation script in each WBSJobCode field that hides the
CompleteWBS filed if no data is entered into the JobCode fieldvar bReady =
true; if(this.getField("WBSJobCode1").value.length == 0) bReady = false;
else if(this.getField("WBSJobCode1").value.length == 7) bReady = true;
if(bReady) this.getField("CompleteWBS1").display = display.visible;
else this.getField("CompleteWBS1").display = display.hidden*

Likes

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
Reply
Loading...
Adobe Community Professional ,
Feb 04, 2020

Copy link to clipboard

Copied

Your code is difficult to read.

Likes

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
Reply
Loading...
New Here ,
Feb 04, 2020

Copy link to clipboard

Copied

I agree and I am sure there is a much more simple way to write the script
to get my end results. It is a form for government use and I cannot send
out the entire form. I will see if I can delete all protected info and
email the portion with the javascript code. Would that work?

Likes

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
Reply
Loading...
Adobe Community Professional ,
Feb 04, 2020

Copy link to clipboard

Copied

Use a external Javascript editor like notepad++.

Likes

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
Reply
Loading...
New Here ,
Feb 04, 2020

Copy link to clipboard

Copied

Hi,
If you want the field to only accept numbers, but still allow initial zeros,
use the following code as its custom Keystroke script (under Properties -
Format - Custom):
*if (event.change) event.rc = /^\d+$/.test(event.change);*
Note that using this code you won't be able to enter the negative symbol,
or a comma, etc. Only digits.

Above post is from Adobe Support Community

Likes

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
Reply
Loading...
New Here ,
Feb 04, 2020

Copy link to clipboard

Copied

Hi all,

My IT department was able to correct my script. Thank you all for the help!!

Likes

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
Reply
Loading...
JMC08 LATEST
Community Beginner ,
Jun 22, 2020

Copy link to clipboard

Copied

thank you

Likes

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
Reply
Loading...
New Here ,
Aug 27, 2018

Copy link to clipboard

Copied

Thanks ever so much!!! That worked.

Likes

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
Reply
Loading...
Resources
Trending Issue & Solution
Edit PDF in Adobe Acrobat Pro DC